Topic - Stored Procedures Part 1

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.

Reading (all required)

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 

Lectures

Lecture - Getting Started with Stored Procedures in SQL Server

Assignments

COP4709 Spring 2013 Assignments - Week 3 assignment.