Creating and Using Stored Procedures

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

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

This is very good video , Thanks a lot

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

It's good video for beginner's

It's good video Thank You

Thanks for the effort!

This video helped me a lot.

Thanks asp .net forum.

nice video helps out alot

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

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

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

procedure.

Nice video. :-)

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