insert into server(....) select (....) from client c where c.recordID not in (select recordID from server)如果没有 recordID就自己间一个好了 select identity(int,1,1),..... into #T from client
zouwork(了解)说得好像可以,我还没试,再问一个一会一起结帐。执行的时候出了异常: ResultSet is closed!不知道是什么问题??
select (....) from client c
where c.recordID not in (select recordID from server)如果没有 recordID就自己间一个好了
select identity(int,1,1),..... into #T
from client
ResultSet is closed!不知道是什么问题??