New Transact SQL Video Tutorial: Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard

Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard - view details

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!

---

• Source: http://www.LearnTransactSQL.com
• Category: Stored Procedure Programming, Error Handling, and Passing Resultsets to the Client
• Skill Level: 100 (Beginner)
• Length: 15:54 (9.09MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sp_help, sproc, procs, , beginner, beginning, for beginners, introduction, step by step