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