SQL 2008 Series: Introduction to Stored Procedures
This Video tutorial describes stored procedures. It is a tutorial on 101 of stored procedures. Stored procedures in SQL are very useful in certain situations. This video briefly describes on how to write a stored procedure.
Stored Procedure also called as sprocs are basically a bunch a T-sql statements bundled up.
They are generally called using the EXEC command.
Stored procedures can take one or more parameters.
SQL server also has its own stored procedures. These are called as System stored procedures or system stored procs.
example: sp_who2
If you learn SQL , you will love the concept of stored procedures. These SQL tutorials cover some basic to a little advanced concepts of stored procedures.
http://www.creativecommit.com