CourtesyIndia.com
Trusted since 2005.
 home / software / tips and tricks / How to drop stored procedure if it exists before creating the stored procedure?

How to drop stored procedure if it exists before creating the stored procedure?

Updated:  07/13/2010 11:07 AM
Author:  Shiju Mathews

Status:    Resolved.

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.



Where
  • HumanResource is the schema name
  • SalaryList is the stored procedure name

    This script will first delete the stored procedure if it exist, and then create the stored procedure.

    • Tips and Tricks

    Interview Questions for C#

    Interview Questions for ASP.Net

    Interview Questions for SQL Server

    Tags: How to drop stored procedure if it exists before creating the stored procedure?
    Updated on: November 2024