怎样用触发器将a表中删除的记录添加到b表中,a,b表的结构相同。 create trig insert_t on afor deleteasinsert into b select * from deleted 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create table trigger on a表for deleteas insert B表 select * from deleted create trig insert_t on afor deleteasinsert into b select * from deleted create trigger test on a for delete as insert into b select * from deleted create trigger triab on afor deleteasinsert into b select * from deleted SQL数据库无法复制 isnull 为什么数据库文件无法复制? 触发器的问题 求教,外连接问题,有图有真相,盼大牛入,是否是MSSQL2k bug 请问这句sql语句执行后为什么说group by 附近有语法错误,怎么改? 单个存储过程参数接受多个值的问题? 如何使用PATINDEX函数!!!!!急急急急急!!!!!! 怎么样在数据表中插入两段文字 各位高手,帮忙一下,完全复制数据库的问题?急! 弱弱的问:判断一个数据库存在,然后将它删除的SQL语句是什么???? 如何判断一个表中某一字段是否存在?能不能向判断数据库和表那样?
for delete
as
insert B表 select * from deleted
for delete
as
insert into b select * from deleted
insert into b select * from deleted
for delete
as
insert into b select * from deleted