Ever created a bunch of stored procedures for testing purposes and went to drop them but couldn’t remember all the names you created? A way to avoid this is to group multiple stored procedures under a single name. The following is the syntax for grouping:
create procedure1as .... .... GOcreate procedure ;2as .... .... GOExample:create procedure ;1as .... .... GOcreate procedure ;2as .... .... GO
The number assigned for each stored procedure will vary from 1 TO 32767. If you want to execute the stored procedure:
exec test;1exec test;2 ... etcDrop all stored procedures using the drop procedure test.
Note: This tip works for all MS SQL 2000 flavors.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
