Category: SQL Server
view more software Tips and Tricks
Updated: 07/13/2010 11:07 AM
Author: Shiju Mathews
While design phases it is advantage to add some script to drop stored procedure if it exists. ’ Alter Procedure’ is an alternate way to accomplish this. Use the following script to for this task.
This script will first delete the stored procedure if it exist, and then create the stored procedure.