这个触发器想实现baobiao里面第七列中的值变化后将本表经营税金一项改变
if exists(select name from sysobjects
where xtype='TR' and name='shouru_total_tr')
drop trigger shouru_total_tr
go
create trigger shouru_total_tr on dbo.baobiao
for update
as
begin
if(COLUMNS_UPDATED()&64)>0
update baobiao
set baobiao.值=(select inserted.值 from inserted)
where and baobiao.输入='经营税金' and baobiao.项目编号=(select 项目编号 from deleted)
end
GO
请问为什么执行之后报错:数据无效
在线等 谢谢
if exists(select name from sysobjects
where xtype='TR' and name='shouru_total_tr')
drop trigger shouru_total_tr
go
create trigger shouru_total_tr on dbo.baobiao
for update
as
begin
if(COLUMNS_UPDATED()&64)>0
update baobiao
set baobiao.值=(select inserted.值 from inserted)
where and baobiao.输入='经营税金' and baobiao.项目编号=(select 项目编号 from deleted)
end
GO
请问为什么执行之后报错:数据无效
在线等 谢谢
如果没有if的话 岂不是没有判断条件了