- View Offline
- 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
- Hi! I'm Martin Guidry and welcome to SQL Server Triggers, Stored Procedures, and Functions. I'll start by showing you how to create stored procedures using T-SQL or C sharp code. Then show you how to use SQL Server Management Studio to simplify database development. We'll see how to create triggers using SQL Server Management Studio and we'll take a look at the Common Language Runtime and how it enables us to create more powerful, faster performing stored procedures, and functions. We'll end with using Visual Studio to create a web application that utilizes the stored procedures created earlier in the course.
We'll be covering all these features plus best practices and techniques for avoiding common problems. Now let's get started with SQL Server Triggers, Stored Procedures, and Functions.