How to Use the exercise files SQL Server
Video: How to Use the exercise files SQL ServerUsing the exercise files provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions
- Next steps
Using the exercise files provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions
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.
- 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
Using the exercise files
The exercise files for this course are organized into folders by chapter. Each chapter has an individual exercise file for the individual section. So for example Ch03 section 05 exercise file looks like this. This is stored in a text file even though it's actually SQL code. We will be copying and pasting this code into Management Studio and run into there. Don't do it just yet. I know you're anxious to get started, but go ahead and wait until we get to the individual section before you run in any of this code.
There are currently no FAQs about SQL Server: Triggers, Stored Procedures, and Functions.