insert into 表(字段) select name from 表1 where 字段 not in (select 字段 from 表)
DECLARE tb CURSOR LOCAL FAST_FORWARDFORSELECT name FROM tbOPEN tbFETCH next from tbWHILE @@FETCH_STATUS = 0BEGIN insert into 表(字段) select name from 表1 where 字段 not in (select 字段 from 表) ENDCLOSE tbDEALLOCATE tb
insert into 表(字段) select name from 表1 where xx字段 not in (select xx字段 from 表)实在反驳不了八楼有什么错误,呵呵正解
select name into table_A from table_B where ...
inset into tb slect name from tb1 where not in(??)
insert into 表(字段)
select name from 表1 where 字段 not in (select 字段 from 表)
DECLARE tb CURSOR LOCAL FAST_FORWARDFORSELECT name FROM tbOPEN tbFETCH next from tbWHILE @@FETCH_STATUS = 0BEGIN insert into 表(字段)
select name from 表1 where 字段 not in (select 字段 from 表)
ENDCLOSE tbDEALLOCATE tb
select name from 表1 where xx字段 not in (select xx字段 from 表)实在反驳不了八楼有什么错误,呵呵正解