In this demonstration-heavy session, we will take a journey into writing a stored procedure. We will start by discussing the differences between auto-commit and explicit transactions. Next, we dive into batch-terminating vs statement-terminating errors, and how to handle them effectively. Finally, we will compare ad-hoc queries vs stored procedures, and when to use each one.

By the end of this session, you will have a solid understanding of how to write an efficient and effective stored procedure that will help you get the most out of your SQL Server database.