-
StatPress TopPosts
- How to Shrink TempDB in SQL 2005 (2398)
- Stored Procedure to Get SQL Job Execution Status (2339)
- A Busy/Accidental DBA's Guide to Managing VLFs (2306)
- Why Do I Need All These Servers? (2217)
- Stored Procedure to Sequentially Run SQL Agent Jobs (2217)
Archives
- May 2011 (4)
- April 2011 (1)
- January 2011 (1)
- December 2010 (1)
- November 2010 (8)
- October 2010 (3)
- September 2010 (6)
- August 2010 (1)
- July 2010 (2)
- June 2010 (1)
- May 2010 (5)
- April 2010 (11)
- March 2010 (2)
- February 2010 (3)
- January 2010 (3)
- December 2009 (4)
Categories
- Azure (1)
- Backup (1)
- CLR (1)
- Dynamic SQL (1)
- File Management (5)
- General (8)
- PowerShell (6)
- Reporting (1)
- Security (4)
- Security Cache (2)
- SQL University (4)
- Tracing and Profiler (1)
- Troubleshooting (7)
- User Management (6)
- Utilities (22)
Meta
Disclaimer
All thoughts and opinions expressed here do not reflect those of my employer in any way.
Category Archives: Dynamic SQL
Using sp_ExecuteSql to Run Dynamic SQL
Dynamic SQL should be considered a highly specialized tool of last resort and used properly. Misuse can lead to your server and the data stored on it no longer belonging to you. Continue reading
