错了
CREATE TRIGGER T_updateid on _Temp_info
FOR delete,update,insert
AS
begin
insert into _Temp_c (Data_Id) select DataId from deleted where DataId is not null
insert into _Temp_c (Data_Id) select inserted.DataId from inserted,deleted where inserted.DataId is not null
and inserted .DataID<>deleted.DataId
end
GO
那我这么写有问题吗?
CREATE TRIGGER T_updateid on _Temp_info
FOR delete,update,insert
AS
begin
insert into _Temp_c (Data_Id) select DataId from deleted where DataId is not null
insert into _Temp_c (Data_Id) select DataId from inserted where DataId is not null
and inserted .DataID<>deleted.DataId
end
GO