求触发器示例

╮(╯_╰)╭，写个例子给你。。。
CREATE TRIGGER TRIG_B  //创建一个名为TRIG_B的触发器
ON B
FOR INSERT           //触发器的类型为INSERT
AS
BEGIN                        //触发器的触发条件
DECLARE @PRODUCT VARCHAR(20)
SELECT @PRODUCT=B.PRODUCT_B
FROM B
DELETE A WHERE PRODUCT_A=@PRODUCT
END
GO

[[it] 本帖最后由 jacksonchina 于 2008-12-8 15:04 编辑 [/it]]

自己做的触发器的sql语句，给你参考下！！



create trigger tri_update_delete_xs_kc
on xs_kc
for update,delete

as

if update(成绩)
begin
select inserted.课程号,deleted.成绩 as 原成绩,inserted.成绩 as 更新后成绩
from   deleted,inserted
where   deleted.学号=inserted.学号
end

else  if columns_updated()=0
begin
select 被删除的学号=deleted.学号,deleted.课程号,deleted.成绩 as 原成绩
from   deleted

end

else
print '更新了非成绩列'