Stored procedures are critical to the ability to manage large databases. This week we will start with how to create stored procedures and you will build on this ability during the semester.
Very basic article on stored procedures, good first read - http://databases.about.com/od/sqlserver/a/storedprocedure.htm
Article on Stored Procedures with good example - http://www.sqlmag.com/article/tsql3/t-sql-101-stored-procedures-100844 -
MSDN Documentation for CREATE PROCEDURE - http://msdn.microsoft.com/en-us/library/ms187926.aspx
Lecture - Getting Started with Stored Procedures in SQL Server
COP4709 Spring 2013 Assignments - Week 3 assignment.
We are simply going to move to more advanced topics (cursors and dynamic SQL) that you will get to practice through assignments.
Dynamic SQL
Good article on Dynamic SQL - http://www.codeproject.com/Articles/20815/Building-Dynamic-SQL-In-a-Stored-Procedure
Documentation for sp_executesql - http://msdn.microsoft.com/en-us/library/ms188001.aspx
Cursors
Documentation on Cursors - http://msdn.microsoft.com/en-us/library/ms180169.aspx
Lecture - Advanced Stored Procedures