SQL Server Triggers and Constraints in the Application of Comparison
Gao Shui-jua · Computer Knowledge and Technology · 2012
SQL Server provides two main mechanisms to enforce business rules and data integrity: constraint and trigger.Tie main is used to ensure that the input to the data in the column satisfy certain conditions.Trigger is a special procedure,when the data in the table is up dated automatically adjusted in response to insert,update,delete statement.