create trigger triggername on dbo.tablename for insert ????????
trigger的类型是什么for insert,update,delete ??还是其他
可以改一下触发器中的脚本 if exists(* from t_UserInfo where userid not in(select UserID from UserInfoTable) ) begin Insert Into UserInfoTable select * from t_UserInfo where userid not in(select UserID from UserInfoTable) end
for delete
和
for insert
on dbo.tablename
for insert
????????
) begin
Insert Into UserInfoTable select * from t_UserInfo where userid not in(select UserID from UserInfoTable)
end