| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Buried in cloud files? We can help with Spring cleaning!

    Whether you use Dropbox, Drive, G-Suite, OneDrive, Gmail, Slack, Notion, or all of the above, Dokkio will organize your files for you. Try Dokkio (from the makers of PBworks) for free today.

  • Dokkio (from the makers of PBworks) was #2 on Product Hunt! Check out what people are saying by clicking here.

View
 

Topic - Stored Procedures

Page history last edited by Dr. Ron Eaglin 3 years, 11 months ago

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.

 

 Stored Procedures Part 2

 

We are simply going to move to more advanced topics (cursors and dynamic SQL) that you will get to practice through assignments.

 

Reading

 

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 

 

Lectures

 

Lecture - Advanced Stored Procedures

 

 

 

 

Comments (0)

You don't have permission to comment on this page.