有关于一个trigger的问题 Create Trigger update_T1 on T1after updateAs insert into bak_T1select * from deleted /*修改此处*/ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 insert into bak_T1select * from inserted 如果要备份修改后的新值,则将deleted改为inserted即可:Create Trigger update_T1 on T1after updateAs insert into bak_T1select * from INSERTED /*修改此处*/ Create Trigger update_T1 on T1after updateAs insert into bak_T1select * from inserted --每次备份修改前的数据create trigger update_t1 on t1for updateas insert into bak_t1select * from deleted go insert into bak_T1select * from inserted Create Trigger update_T1 on T1after updateAs insert into bak_T1select * from inserted Trigger 有三个临时表(不知道是不是这样叫)inserted,updated,deleted 只有兩個 deleted,insertedupdate 觸發器,更新前的保存在deleted ,更新後的保存在inserted中 SQL复杂查询 日期计算问题 还是多表关联问题 求SQL语句或解决方法 sqlserver 查询语句问题 SQL Server 2008用T-sql 创建数据库及文件组,出现问题,怎样解决? 关于UPDATE动态SQL的问题,应该不难,只因我不会~求标准写法,帮帮忙,先谢谢了~ 在MS-SQL有没有工具可以看一起全部字段描述的 誰知道如何通過sql查詢取得存儲過程 请问在一个存储过程中能不能同时创建一个表,然后修改表结构,如果能,请举例,谢谢 关于SQL远程访问 关于汇总的明显标示的问题!
select * from inserted
Create Trigger update_T1 on T1
after update
As
insert into bak_T1
select * from INSERTED /*修改此处*/
after update
As
insert into bak_T1
select * from inserted
for update
as
insert into bak_t1
select * from deleted
go
select * from inserted
after update
As
insert into bak_T1
select * from inserted