Transaction Isolation - Quiz
Error Handling Testing
Assign Use Variables
SQL Raising Errors
SQL Server Functions
Enforcing Business Rules
Creating Triggers - Exercise
Testing SQLserver Trigger
Stored Procedures - Exercise
Stored Procedure - Quiz
Accessing Remote Data
Enterprise Manager Server
Adding Remote Login
1) trigger_name is the name of the trigger you are going to modify. A trigger is a database object, so it must have a unique name within the database.
2) table is the name of the table on which you will modify the trigger.
3) WITH ENCRYPTION encrypts the text so that it can not be read from the syscomments table.
4) trigger_type is the type of trigger you wish the trigger to become. The type can be INSERT, UPDATE, or DELETE, depending on the type you want the trigger to become.
5) WITH APPEND is an optional statement that indicates to SQL Server that if a trigger of the same type already exists, this trigger should be added.
6) NOT FOR REPLICATION indicates that any replication operations that affect data in the table should not fir the trigger. The code should affect the data anyway,
7) column is used if you wish to test for a specific column to have data inserted or updated into it. Multiple columns can be specified.
8) Bitwise_operator, updated_bitmask, comparison_operator, and column_bitmask all are affected by the COLUMNS_UPDATED clause, which is used to test a bit-filed representing one or more columns that are updated.
9) trigger_code is the Transact-SQL code that you will use to implement your business rules, using the INSERTED and DELETED special trigger tables.