Triggers the update trigger when a specific field update occurs for a SQL Server trigger table _mssql

Copy Code code as follows:

Create Trigger Tr_mastertable_update
On mastertable
After update
As
If update ([Type])--triggers this trigger when the Type field is updated
INSERT INTO masterlogtable
Select
Id
, (case [Type] when 1 Then ' Type1 '
When 2 Then ' Type2 '
When 3 Then ' Type3 '
When 4 Then ' Type4 '
Else ' Typedefault '
End
, Name
From inserted
Go

Add another: Insert and update data will be saved in a temporary table, so use inserted can take out the data, delete the use of deleted can take out the deleted data
Reprint please indicate the source: Http://blog.csdn.net/tjvictor