log inhelp

 | 

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

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Topic - Stored Procedures Part 2

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

Topic - 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.

Printable version