delete from a where id = 4
insert into b values(deleted.ID,deleted.name)
这是两条语句,两个操作,要保证他两个都执行就要用事务而下面的语句
delete from a
output deleted.[ID],deleted.[name]
into c([ID],[name])
where id = 4
这是一个操作吧?
insert into b values(deleted.ID,deleted.name)
这是两条语句,两个操作,要保证他两个都执行就要用事务而下面的语句
delete from a
output deleted.[ID],deleted.[name]
into c([ID],[name])
where id = 4
这是一个操作吧?
insert into b values(deleted.ID,deleted.name)
--
错的,你第二种写法是对的
学习一下下output,http://www.cnblogs.com/aji88/archive/2010/02/24/1672446.html
我现在才知道联机帮助 必须要仔细看