آموزش تریگرها در اس کیو ال سرور

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 Introduction 2m 15s Welcome 51s What you should know 51s Using the exercise files 33s 1. Getting Started 11m 1s Comparing triggers, functions, and procedures 3m 25s Why use a stored procedure? 4m 59s Why use functions? 1m 27s Why use triggers? 1m 10s 2. Installing SQL Server 6m 2s Configuring your environment 4m 53s Downloading and installing a sample database 1m 9s 3. Stored Procedures 26m 25s Creating a stored procedure 2m 46s Modifying a stored procedure 2m 34s Returning data using data sets 3m 45s Returning data using cursors 3m 45s Using input and output parameters 5m 24s Using security and permissions 5m 24s Using transactions 2m 47s 4. User-Defined Functions 11m 56s Creating a user-defined function 4m 59s Exploring single-value functions 4m 18s Exploring table value functions 2m 39s 5. Triggers 9m 31s Using "after" triggers 3m 47s Using "instead of" triggers 2m 9s Using nested triggers 1m 38s Using database-level triggers 1m 57s 6. Putting It All Together 12m 43s Exploring a real-world INSERT procedure 5m 32s Exploring a real-world UPDATE procedure 3m 13s Implementing logging on DELETE 3m 58s 7. Using CLR Assemblies 19m 38s Understanding the Common Language Runtime (CLR) and the .NET framework 1m 52s Using CLR with SQL Server 2012 4m 11s Writing stored procedures with C# .NET 5m 51s Writing functions with .NET 5m 7s Choosing between T-SQL vs. CLR 2m 37s 8. Exploring an ASP.NET Web Application 11m 34s Creating a basic web form and connecting to a database 2m 56s Executing a stored procedure 2m 4s Passing parameters 3m 41s Getting return values 2m 53s Conclusion 1m 43s Next steps 1m 43s