How to Modify a Stored Procedure for an SQL Server


show more Modifying a stored procedure provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions show less
please wait ...

Modifying a stored procedure

Now that we've created a stored procedure, it's likely I would want to change it at some point. The easiest way to modify a stored procedure is to come back to our favorite menu, the Programmability menu, open that up, locate the stored procedure we would like to change, right-click on it, and one of the options in the right-click menu will be Modify. When I click on Modify, it throws some code up on the screen. Notice that lines 8 through 12 here are extremely similar to what I wrote. The only difference is rather than have the keyword CREATE, it has changed it to the keyword ALTER, which makes a lot of sense.

We are not trying to create a new stored procedure anymore, we are trying to modify a stored procedure, and in the SQL world, we use the word alter for when we want to change things. So I could make a small change to my stored procedure, and click on the red exclamation point again. And it will say that it completed my command successfully, which means the stored procedure ha...

Modifying a stored procedure
Video duration: 2m 34s 1h 52m Advanced

Viewers:

Modifying a stored procedure provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...