Erland Sommarskog's - Texts on SQL
After my last post I took a closer look at Erland Sommarskog home page and found some other articles worth reading :
The curse and blessings of dynamic SQL. How you use dynamic SQL, when you should - and when you should notArrays 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.Dynamic Search Conditions. How to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL. 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.How to share data between stored procedures. Different ways of passing sets of data between stored procedures.Ohad.