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: 1663 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
What are the uses of DBCC commands?
The ‘Call Log’ SQL Problem
PRIMARY - FORIEGN KEY ERROR