Articles on Stored Procedures

Documenting Scripts ( 21 June 2000 - Bill Graziano

Passing Dates to a Stored Procedure ( 13 August 2000 - Bill Graziano

Calling COM Objects From T-SQL ( 13 September 2000 - Sean Baird

Stored Procedures: An Overview ( 1 September 2000 - Bill Graziano

Passing a CSV or Array to a Stored Procedure ( 8 September 2000 - Bill Graziano

Using Stored Procedures instead of Dynamic SQL ( 29 November 2000 - Chris Miller

Handling Errors in Stored Procedures ( 5 February 2001 - Garth Wells

Stored Procedures: Returning Data ( 9 April 2001 - Bill Graziano

Paging Recordsets ( 20 February 2001 - Rob Volk

Stored Procedures: Parameters, Inserts and Updates ( 26 February 2001 - Bill Graziano

Handling Custom Errors in a Client Application ( 5 March 2001 - Garth Wells

Using Triggers to Track Database Action History ( 18 September 2001 - Bill Graziano

Using FTP in Transact-SQL ( 1 October 2001 - Mike Femenella

How to NOT trap errors in a stored procedure ( 1 December 2001 - Chris Miller

Simulating Constants Using User Defined Functions ( 24 February 2002 - Guest Authors

Query Recompilation in SQL Server 2000 ( 10 June 2002 - Bill Graziano

How to search all columns of all tables for a keyword? ( 31 July 2002 - Bill Graziano

Globally search and replace data in SQL Server ( 6 November 2002 - Rob Volk

Run CLR code from a stored procedure ( 14 October 2003 - Bill Graziano

An Evaluation of Stored Procedures for the .NET Developer ( 22 March 2004 - Bill Graziano

Managed Data Access Inside SQL Server with ADO.NET and SQLCLR ( 31 May 2005 - Bill Graziano

Writing CLR Stored Procedures in C# - Introduction to C# (Part 1) ( 6 June 2005 - Bill Graziano

Writing CLR Stored Procedures in C# - Returning Data (Part 2) ( 23 June 2005 - Bill Graziano

Debugging Stored Procedures in Visual Studio 2005 ( 25 June 2007 - Chris Rock

Testing with Profiler Custom Events and Database Snapshots ( 22 June 2009 - Mike Femenella

Handling SQL Server Errors ( 5 April 2010 - Bill Graziano