I wanted some reference book on dynamic sql exclusively.Can any of you suggest one?
Mar 04 '10 at 06:29 PM
Mar 04 '10 at 07:13 PM
Kev Riley ♦♦
I know it is not a book, but I would definitely start with "The Curse and Blessing of Dynamic SQL" at http://www.sommarskog.se/dynamic_sql.html It is written by an MVP and is impressively detailed.
Mar 04 '10 at 07:08 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Mar 04 '10 at 06:29 PM
Seen: 912 times
Last Updated: Mar 04 '10 at 07:13 PM
Execute a Query against multiple servers
Compatibility Level Change
Output query results to csv files
Phil Factor SQL Speed Phreak Challenge #4 - The Log Parsing Problem
Optimize nested/iterative query/queries
Linked server connecting problem
Dynamic index reorganise script failing
T-SQL And Statement
The Suggested Shopping List Problem...
Running scripts in ssms