Join Martin Guidry for an in-depth discussion in this video Creating a stored procedure, part of SQL Server: Triggers Stored Procedures and Functions.
I'd like to talk to you little bit about creating stored procedures in…Microsoft SQL Server.…To do this we're going to start of with the keyword CREATE and then the keyword PROCEDURE.…After that we need to give it a name.…Well, we have lots of options on naming.…Almost any combination of letters and numbers and punctuation marks will work.…One of the few exceptions is you are not allowed to start with a numeral.…So if I try to type in numerals at the beginning, the machine will get upset…with that and put that little red squiggly line in there.…
That is because you're not allowed to start with numerals.…You are allowed to end with numerals or have numerals anywhere else in the name.…But just as a matter of preference I typically avoid both punctuation marks and…numerals and go with just text.…Once we've decided on a name we will need the keyword AS and the keyword BEGIN.…I typically put those on separate lines, but that's not necessary.…You could put all of this on one line.…I just find it makes it a little easier to read spaced out like this.…
- 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.