Insert into... where condition... delete * from ... where condition...
不好意思,打开后过了一会才提交,没刷新。我可不是有意重复回答的。完全同意lkwyong(王勇)。
with query do Begintrans insert into 表名2 select * from 表名1 where 条件 delete from 表名1 where 条件 committrans
某条件具备? 我理解是某个字段变成某个值。 那最好用触发器了。 比如用SQL SERVER:CREATE TRIGGER TESTTRIGGER on TEST for INSERT,update asINSERT INTO TEST2 SELECT * FROM INSERTED WHERE COL=你设置的值 DELETE TEST FROM TEST,INSERTED WHERE TEST.KEY=INSERTED.KEY AND COL=你设置的值 GO
delete * from ... where condition...
Begintrans
insert into 表名2 select * from 表名1 where 条件
delete from 表名1 where 条件
committrans
我理解是某个字段变成某个值。
那最好用触发器了。
比如用SQL SERVER:CREATE TRIGGER TESTTRIGGER
on TEST
for INSERT,update
asINSERT INTO TEST2 SELECT * FROM INSERTED WHERE COL=你设置的值
DELETE TEST FROM TEST,INSERTED WHERE TEST.KEY=INSERTED.KEY
AND COL=你设置的值
GO