|
|
-
Madhivanan Liked 7 Months ago through Blogs | 1 Point
In this blog post, I have already blogged about knowing version of the server using different methods. One other method is to make use of @@MicrosoftVersion frunction
select @@MicrosoftVersion,CAST(@@MicrosoftVersion as binary(5))
The result is
-...
|
|
|
-
Madhivanan Commented 7 Months ago through Blogs | 1 Point
Thanks Manoj. Thats good one...
|
-
Madhivanan Posted 7 Months ago through Blogs | 10 Points
The batch separator in SQL Server signals the end of the batch. By default SQL Server uses GO as the batch separator. However often people get confused on when they should use it compulsorily. Here are the cases where you must use batch separator
1 A...
|
-
Madhivanan Commented 7 Months ago through Blogs | 1 Point
See if you get correct result
select t1.TranNum,t1.sno+t2.sno-1 from
(
select TranNum , max(tranSeq)+row_number() over (partition by TranNum order by TranNum) as sno from TableA
group by TranNum
) as t1 inner join
(
...
|
-
Madhivanan Commented 7 Months ago through Blogs | 1 Point
vmanfredi, can you post some sample data with expected result?...
|
|
|
-
Madhivanan Posted 8 Months ago through Blogs | 10 Points
I had a requirement to convert table data in XML format. The format is expected to be
. . .
Create this testing table create table testing
(
id int,
first_nam...
|
-
Madhivanan Liked 8 Months ago through Blogs | 1 Point
How do I view the script of the DDL triggers?
The answer is not
sp_helptext 'DDL trigger'
Because DDL triggers are defined at database/server level and not at any table level
So they are not stored in a system objects like sys.objects and the...
|
-
Madhivanan Commented 8 Months ago through Blogs | 1 Point
Thanks Datta for the link :)...
|