1. sql觸發器怎樣更新數據
--創建需觸發的表
create table cfq(
a int,
b int
)
--創建觸發器，監視該表
CREATE TRIGGER t_cfq ON dbo.cfq
for INSERT, UPDATE, DELETE
AS
begin
set nocount off
declare @a int
select @a=a from cfq
update cfq set b=@a where a=@a
end
--觸動觸發器
insert into cfq(a,b) select 2,null
insert into cfq(a,b) select 3,null
select * from cfq
所得結果
a b
2 2
3 3
2. sql server 寫一個觸發器指定欄位更新才觸發
createtriggertest
on表一
afterupdate
asbegin
updatebsetb.欄位4=a.欄位2,b.欄位5=a.欄位3from表二b,insertedawherea.表一和表二的關聯欄位=b.表一和表二的關聯欄位andb.欄位5=1
end
點這個地方就能私聊，加一下求求
3. SQL update更新多個表欄位列觸發器
設A表有ID為主鍵
create trigger Myup
on A表
for update
as
if update(name)
begin
update B set NAME=inserted.NAME where exists(select * from inserted inner join deleted on inserted.ID=deleted.ID where deleted.name=B.NAME)
update C set NAME1=inserted.NAME where exists(select * from inserted inner join deleted on inserted.ID=deleted.ID where deleted.name=C.NAME1)
update D set NAME=inserted.NAME where exists(select * from inserted inner join deleted on inserted.ID=deleted.ID where deleted.name=D.NAME)
end
可以滿足批更新操作