Join Martin Guidry for an in-depth discussion in this video Modifying a stored procedure, part of SQL Server: Triggers Stored Procedures and Functions.
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 has been modified.…
- Comparing triggers, functions, and stored procedures
- Installing and configuring SQL Server
- Creating a stored procedure
- Returning data using data sets
- Creating user-defined functions
- Using "after," "instead," and nested triggers
- Modifying existing stored procedures
- Implementing logging on DELETE
- Choosing between T-SQL and CLR
- Executing a stored procedure
- Passing parameters
Skill Level Advanced
1. Getting Started
2. Installing SQL Server
Configuring your environment4m 53s
3. Stored Procedures
4. User-Defined Functions
6. Putting It All Together
7. Using CLR Assemblies
8. Exploring an ASP.NET Web Application
Next steps1m 43s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.