SQL Server: Triggers, Stored Procedures, and Functions

Investigates several key database-programming concepts and how to combine them to create a high-quality database with Microsoft SQL Server.This course investigates several key database-programming concepts: triggers, stored procedures, functions, and .NET CLR (Common Language Runtime) assemblies. Author Martin Guidry shows how to combine these techniques and create a high-quality database using Microsoft SQL Server 2012. The course also covers real-world uses of the INSERT, UPDATE, and DELETE procedures, and how to build a basic web form to connect to your database. Topics include: Comparing triggers, functions, and stored procedures Installing and configuring SQL Server Creating a stored procedure Returning data using data sets Creating user-defined functions Using "after," "instead," and nested triggers Modifying existing stored procedures Implementing logging on DELETE Choosing between T-SQL and CLR Executing a stored procedure Passing parameters