Question

SQL server2008 中的触发器怎么定义，以及应用

Answer 1

create triger tr_类型_触发器名字 on 表名
触发类型：after | instead of
操作类型：insert | delete | update
as
begin
代码
end
插入数据同时获得自动增长的ID
insert into USERS output inserted.* values('111','111');

删除数据的同时 插入数据
select * from USERS

go
create trigger test on USERS
after
delete
as
insert into USERS (Name,Sex)
select Name,Sex from deleted
go

Answer 2

这个得看你怎么定义的啊。建议你贴出你的触发器脚本。create trigger nameon tbbefore insert--插入前after insert--插入后for insert--插入后as........