select id from PNEWOBJECT
update PNEWOBJECT set id=id+1
insert into POBJECT (IOBJECT, SNAME, ITABLE,IREFERENCE) values(20001, 'testSQL', 1032,0)
其中20001就是通过SELECT查出来的,怎么把三句合并啊,合并出错,能把1、3合成一句也可以
update PNEWOBJECT set id=id+1
insert into POBJECT (IOBJECT, SNAME, ITABLE,IREFERENCE) values(20001, 'testSQL', 1032,0)
其中20001就是通过SELECT查出来的,怎么把三句合并啊,合并出错,能把1、3合成一句也可以
select isnull(max(id),0)+1, 'testSQL',1032,0 from PNEWOBJECT