Question

SQL触发器写法

我想写一个触发器，当table表中的a,b,c字段为True时，使得d字段更新为true，在线等

Answer 1

create trigger dbo.SetTrue
on YourTable for update
as
if exists (select 'True'
from inserted as i
where i.a = true and i.b = true and i.c = true )
update YourTable
set YourTable.d = true
where YourTable.a = true and YourTable.b = true and YourTable.c = true

Answer 2

ALTER trigger [dbo].[trg_allwage]
on [dbo].[Factory]
after insert
as
begin
declare @allwages float
select @allwages=sum(wages) from dbo.employee
update dbo.Factory set allwages=@allwages where factory='A1001'
end

这样改试一下。

Answer 3

declare @wages float,@allwages float
select @wages=sum(wages) from dbo.employee
print @allwages
update dbo.Factory set allwages=@wages where factory='A1001'

Answer 4

create trigger t_update on [table]
for update
as
update [table] set d=1 where a=1 and b=1 and c=1