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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy