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: 1098 times
Last Updated: Mar 04 '10 at 07:13 PM
Execute a Query against multiple servers
PRIMARY - FORIEGN KEY ERROR
How do I search for a specific letter in a table?
The ‘Call Log’ SQL Problem
The ‘SSN matching’ SQL Problem
The 'Subscription List' SQL Problem
what is the advantage of giving null value to unique constrain
how to select Bottom( N) rows in a table through single query.
What are the pros and cons of using a temporary dates table instead of a permanent one?
Output query results to csv files