Day 15. Day Writing and Executing Stored Procedures
Today, you are going to learn how to write and manage stored procedures and how the server uses them. Stored procedures are nothing more than T-SQL statements that have been saved within the database and can be executed by referencing the name with which it was saved. To see this, some of the topics that are covered in today's lesson are
Understanding stored procedures
Writing your first stored procedure
Working with parameters
Returning procedure status
After learning the basics of stored procedures in this lesson, you will then learn some of the more advanced issues of stored procedures in tomorrow's lesson.
Stored procedures are batches of T-SQL statements that SQL Server stores in the database ...
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.