SQL Server: Triggers, Stored Procedures, and Functions

Author

Released

9/24/2012

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

Skill Level Advanced

1h 52m

Duration

399,694

Views

Show MoreShow Less

- Hi! I'm Martin Guidry and welcome to SQL ServerTriggers, Stored Procedures, and Functions.I'll start by showing you how to create stored proceduresusing T-SQL or C sharp code.Then show you how to use SQL Server Management Studioto simplify database development.We'll see how to create triggersusing SQL Server Management Studioand we'll take a look at the Common Language Runtimeand how it enables us to create more powerful,faster performing stored procedures, and functions.We'll end with using Visual Studio to createa web application that utilizes the stored procedurescreated earlier in the course.

We'll be covering all these features plus best practicesand techniques for avoiding common problems.Now let's get started with SQL ServerTriggers, Stored Procedures, and Functions.