Create Trigger update_T1 on T1
after update
As
insert into bak_T1
select * from deleted /*修改此处*/
after update
As
insert into bak_T1
select * from deleted /*修改此处*/
解决方案 »
- 求 SQL或存儲過程
- MYSQL 备份/还原 问题,急!!!
- 按部门名称查询出人工的人数大于等于100(表 emp_employee 部门名称:department,员工姓名:chnalias)
- 问个关于分布式查询的简单问题
- 日志文件问题,高手请进,up有分!在线等待!
- 菜鸟问题,备份设备问题。
- CSDN高手们在那里,小弟这个问题问了好多次了,还没找到答案啊。。急。。。。
- sql与access之间导入导出重复数据,违反主键索引怎么解决?请楼上的高手赐教?
- 帮忙简化一下存储过程
- 出错:java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
- 关于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