Welcome to another exciting installment of “<STRIKE>Deep Thoughts by Jack Handy<BR><BR></STRIKE> <BR>T-SQL Theory questions that only Maxer seems to care about ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...

Table-valued parameters are the long-awaited solution to a specific SQL Server shortcoming that has plagued developers for quite some time: SQL Server doesn't provide a built-in way to send multiple ...

Ok, seeing as how I couldn't find a split() function in T-SQL, and I need to import data from a Table that has this concatenated field of ID's, I wrote my own split ...

Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...