Writing Stored Procedures for Microsoft SQL Server

The Changing of the Code—Altering Stored Procedures

Anyone who has ever programmed can tell you that there are times when the original code you rolled out to your users does not provide the correct functionality. Sometimes this is because of a minor problem with the code; other times, it is because the code is completely wrong. It used to be very difficult and somewhat complicated to modify stored procedures. SQL Server 2000 provides an easy way to modify stored procedures without losing any important information.

The Old Way

If you worked with any of the 6.x versions of SQL Server, you know that modifying stored procedures could be very difficult. This is because none of those versions provided a real way to perform this functionality. Instead, ...