Page view counter

Creating and Using Stored Procedures

Please install Silverlight or click download to watch video locally.

This video expands on the topic of Stored Procedures which was introduced several lessons ago. In this video we explain the basic syntax to create and update stored procedures, using input and output parameters, return values, declaring variables and adding other T-SQL programming elements into you stored procedures, how to execute your stored procedures from the query window, and finally the Visual Basic and C# syntax required to utilize stored procedures in your own applications.

Duration: 42 minutes, 34 seconds

Date: 14 November 2006

Watch    Video   |   Download    Video

Video downloads: WMV

Audio downloads:

Comments : 18

Leave a Comment

Mirek_Kordos : On March 09, 2008 10:24 AM said:

A great video. The fastest way to learn how to create and execute stored procedures, both writing code and using components.

Alexander1 : On March 19, 2008 6:23 PM said:

This is a good video to learn how to create Stored Procedures in SQL server 2005.

m3loma : On March 23, 2008 6:34 AM said:

This is very good video , Thanks a lot

m2008huan : On April 04, 2008 10:09 PM said:

I like it! Thank You Very Much!!!!

mahesh3447 : On April 17, 2008 2:09 AM said:

It's good video for beginner's

ziadqadour : On May 03, 2008 10:59 AM said:

It's good video Thank You

engineerachu : On May 30, 2008 3:38 AM said:

Thanks for the effort!

Punithkumar : On May 30, 2008 7:04 AM said:

This video helped me a lot.

Thanks asp .net forum.

bluerainsigma : On June 05, 2008 11:17 AM said:

nice video helps out alot

parrynee : On June 09, 2008 11:10 PM said:

Nice video. But Where can I get the sample code?

monster1 : On July 29, 2008 5:09 PM said:

I think this is the first one:

CREATE PROCEDURE dbo.EmployeesByState

AS

BEGIN

SELECT c.LastName, e.Title, sp.[Name]

FROM HumanResources.Employee e

INNER JOIN Person.Contact c ON e.ContactID = c.ContactID

INNER JOIN HumanResources.EmployeeAddress ea ON ea.EmployeeID = e.EmployeeID

INNER JOIN Person.Address a ON ea.AddressID = a.AddressID

INNER JOIN Person.StateProvince sp on a.StateProvinceID = sp.StateProvinceID

ORDER BY sp.[Name], e.Title, c.LastName

END

patelr28 : On August 28, 2008 12:31 PM said:

This is really a good video for basic of creating of stored

procedure.

tmorton : On September 17, 2008 1:24 PM said:

Nice video. :-)

shamim81 : On November 10, 2008 9:23 AM said:

Please let me know how to start execution of stored procedure using asp.net 2008. you can send info at itprofessional81@gmail.com

M Athar : On December 01, 2008 9:43 AM said:

Great video for beginners to learn about the store procedure.  

amin_pucit : On February 18, 2009 5:45 AM said:

Nice video

bugmenot1337 : On March 13, 2009 2:33 PM said:

Check out more video tutorials for SQL Server at

http://wtv.watchtechvideos.com

Do Join and share videos which you have which will help community and upcoming Programmers and DBA's to learn SQL Server.

ianjose : On June 12, 2009 12:01 AM said:

this is good video for helping us develop our new programs send me by e-mail for more updates about sql server videos thanks, my email is diamseianjose@yahoo.com

Leave a Comment

You must be logged in to leave a comment. Click here to log in.

Microsoft Communities