Erland Sommarskog , SQL Server MVP had an interesting list of articles
- The curse and blessings of dynamic SQL. How you use dynamic SQL, when you should - and when you should not. (Added June 2001, Latest update: December 2003.) Korean, German and Spanish translations available.
- 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. Latest update: February 2004.) German translation available.
- 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 and ADO .Net. (Added July 2003. Latest update: February 2004. )
- How to share data between stored procedures. Different ways of passing sets of data between stored procedures. (Added July 2001, Latest update: 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 December 2004)