I wanted some reference book on dynamic sql exclusively.Can any of you suggest one?
Mar 04, 2010 at 06:29 PM
Mar 04, 2010 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, 2010 at 07:08 PM
especially because the article points out why most of the time, you probably won't need it...
Great link Tim thanks.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
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, 2010 at 06:29 PM
Seen: 1667 times
Last Updated: Mar 04, 2010 at 07:13 PM
Execute a Query against multiple servers
How do you create a non clustered index?
Backup fails when run from stored procedure
Statistics on the databases
What reference book should every DBA/Dev have?
Finding if identity is on any tables in the database
Output query results to csv files
The ‘Call Log’ SQL Problem
PRIMARY - FORIEGN KEY ERROR
Encryption of results sent by SQL Server Stored Procedure