Dropping Multiple Stored procedures at once in SQL SERVER 2008

We can drop multiple procedure at a time by comma separating the procedures.


Dropping Single Procedure:

DROP PROCEDURE dbo.uspGetSalesbyMonth

Dropping Mutiple Procedure:

DROP PROCEDURE dbo.uspGetSalesbyMonth, dbo.uspUpdateSalesQuotes, dbo.uspGetSalesByYear;

Thanks for reading :)
Ebook Download
View all
Learn
View all