help.net

The Curse and Blessings of Dynamic SQL

An SQL text by Erland Sommarskog, SQL Server MVP.

Erland has also posted an interesting list of articles

Texts on SQL

This is a small collection of texts about some features in SQL Server that people frequently ask about in the newsgroups about MS SQL Server. Rather than being a FAQ with many questions with short answers, these are in-depth articles on some of my favourite topics

• The curse and blessings of dynamic SQL. How you use dynamic SQL, when you should - and when you should not. (Added June 2001, Updated May 2003)
• Arrays and Lists in SQL Server. Several methods on how to pass an array of values from a client to SQL Server, and performance data about the methods. (Added March 2003)
• Dynamic Search Conditions. How to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL. (Added May 2003)
• Implementing Error Handling with Stored Procedures and Error Handling in SQL Server – a Background. Two articles on error handling in SQL Server. I have split the topic on two articles, so if you only want to learn how to implement your error handling you can start there. The background article is more of interest to intermediate and advanced SQL users. Both articles also cover ADO. (New! Added July 2003)
• How to share data between stored procedures. Different ways of passing sets of data between stored procedures. (Added July 2001, Updated May 2003)
• Connecting to MS SQL Server from Unix. A brief summary of what's available. Since I don't work with Unix myself, not extremely well-informed, but people have kept asking me about this. (Added Jan 1999, Last update March 2003)