In this series we'll dive deeper in to Transact SQL by looking at Stored Procedures, Transactions, Views, Triggers, User Defined Functions and more.
Total Time: 41 Minutes Total Videos: 3
In this tutorial I'll demonstrate how to create basic stored procedures. In the following videos in this lesson, we'll examine the purpose and utility of stored procedures, how they work, and will use this foundation to explain additional stored procedure functionality and options.
In this video tutorial we explore why Stored Procedures are important as you develop your database applications and maintain the data. We also will look at the notion of an execution plan and how SQL Server creates an execution plan for your stored procedure then how it caches that execution plan to improve performance.
In this tutorial we expand on our knowledge of stored procedures and allow the consumer of a stored procedure to provide input parameters and how to receive scalar output parameters and return values from a stored procedure.
