Question

如何创建触发器insert、update、delete

Answer 1

使用create trigger命令创建触发器
语法如下
create trigger trigger_name
on{table|view}
[with encryption]
{
{{for|after|insted of}{[delete][,][insert][,][update]}
[not for replication]
as
[{if update (column)
[{and|or} update (column)]
[...n]
|if (columns_updated(){bitwise_operator}updated_bitmask)
{comparison_operator}column_bitmask[...n]
}]
sql_statement [...n]
}
}
至于存储过程是使用create procedure创建存储过程的
语法如下
create procedure procedure_name[;version number]
[{@parament date_type}
[VARYING] [=default value][OUTPUT]
][,...n]
[with
{recompite|encryption|recompile,encryption}]
[for replication]
as sql_statement [...n]

Answer 2

Create Trigger trigger_1 On table_1
For Insert, Update, Delete
As
Select * From insterted
Select * From deleted

Go
--你的代码