set identity_insert on
insert into tablename select * from tablenam
where tablenam.a not in (select a from tablename )
set identity_insert off
insert into tablename select * from tablenam
where tablenam.a not in (select a from tablename )
set identity_insert off
set identity_insert on
insert into tablename select * from tablenam
where tablenam.a not in (select a from tablename )
set identity_insert off
提示
服务器: 消息 156,级别 15,状态 1,行 1
在关键字 'on' 附近有语法错误。
服务器: 消息 156,级别 15,状态 1,行 4
在关键字 'off' 附近有语法错误。
set identity_insert on
insert into tablename(把字段名写上) select * from tablenam
where tablenam.a not in (select a from tablename )
set identity_insert off
insert into tablename(a,b,v,k) select a,b,v,k from tablenam
where tablenam.a not in ('select tablename.a from tablename ' )
select * from tablename
要求版主退回我的20分
--改成这样看看 **** 这个是对的,只要你在insert中把所有的字段名加上就没问题了
set identity_insert on
insert into tablename(把字段名写上) select * from tablenam
where tablenam.a not in (select a from tablename )
set identity_insert off