stored procedure SQL Server


show more Creating 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 ...

Creating a stored procedure

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 l...

Creating a stored procedure
Video duration: 2m 46s 1h 52m Advanced

Viewers:

Creating 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 ...