Description:
Stored procedures are, quite simply, the most popular way that modern database developers allow applications to interface with the
database. This video is an excellent introduction to what a stored procedure is, how to use ("execute") stored procedures, and
the syntax and tools used in creating/managing stored procedures.
The Enterprise Manager allows you to quickly create generic stored procedures using the Create Stored Procedure Wizard.
Is it a good wizard; i.e., should you use it? Maybe - this video gives you the pros and cons of using the Enterprise Manager to manage stored procedures.
Highlights from this video:
- What is a stored procedure?
- Example stored procedures
- Using the Create Stored Procedure Wizard
- Suggestions for using stored procs
- Naming Conventions
- Creating and Editing Stored Procedures with TSQL
Note: This should be considered a "Must-See" video for all newbies!
Download
and watch this video