CREATE TRIGGER TRIGGER_insert ON [dbo].[user]
after insert
for each row
as begin
insert into usermail values(new.userid,new.username,'di')
end
上面的触发器哪错了 是在mssqlserver2000下的 大虾帮忙啊!!!
after insert
for each row
as begin
insert into usermail values(new.userid,new.username,'di')
end
上面的触发器哪错了 是在mssqlserver2000下的 大虾帮忙啊!!!
after insert
--for each row
as --begin
--insert into usermail values(new.userid,new.username,'di')
insert into usermail select userid,username,'di' from inserted
--end
after insert as insert into usermail('字段1','字段2','字段3') select userid,userid, di from inserted--- values(new.userid,new.userid,'di')