Viewing 7 posts - 1 through 7 (of 7 total)
- to change the n-th element's value where n is not known before hand (i.e. avoid putting some constant like [1] in the xpath),
you should use sql:variable function like this:
declare...
March 14, 2012 at 2:41 pm
Main reason to do this is to do not:
1. Hardcore column names in case of using PIVOT clause.
2. Query metadata in case of dynamic SQL building.
December 14, 2011 at 2:05 pm
Dynamic solution is better than based on cursor one. Tat is the reason of my solution.
December 14, 2011 at 10:42 am
INFORMATION_SCHEMA.ROUTINES does not return triggers data, look here:
ROUTINE_TYPE
nvarchar(20)
Returns PROCEDURE for stored procedures, and FUNCTION for functions.
September 29, 2011 at 2:59 am
To easily transpose columns into rows with its names you should use XML. In my blog I was described this with example: http://sql-tricks.blogspot.com/2011/04/sql-server-rows-transpose.html
April 8, 2011 at 7:28 am
To easily transpose columns into rows with its names you should use XML. In my blog I was described this with example:
April 8, 2011 at 4:03 am
To easily transpose columns into rows with its names you should use XML. In my blog I was described this solution with example:
April 8, 2011 at 4:00 am
Viewing 7 posts - 1 through 7 (of 7 total)