这句有错（它提示where 附近有语法错误）我不知道错在哪里？

[ItOldHorse]

这句有错（它提示where 附近有语法错误）我不知道错在哪里？
insert into dangank_byg(bianhao,xingming) values(12,’wq’) where 12 not in (select distinct bianhao from dangank_byg)

[pengdali]

insert into dangank_byg(bianhao,xingming) select 12,'wq' where 12 not in (select distinct bianhao from dangank_byg)

[pengdali]

insert into dangank_byg(bianhao,xingming) select 12,'wq' where 12 not in (select distinct bianhao from dangank_byg)

[yaiger]

语法都不对，能通吗？

select 12,'wq' where 12 not in (select distinct bianhao from dangank_byg)

能这样字写吗？真是昏倒， select后面连from都没有

[yaiger]

啊，抱歉，没有注意是sqlserver，那是可以写的

不过建议不用要not in 和 distinct 用 not exists好了，效率高

[pengdali]

INSERT INTO O_F_PROCESS
(OID, NEEDTIME, CARI, CARJ, STREET, AREA1, AREA2, SHOWI, SHOWJ, ARRIVED)
SELECT O_F_SAVE.OID, O_F_SAVE.NEEDTIME, COORDINATE.CARI, COORDINATE.CARJ,
COORDINATE.STREET, 0, 0, O_F_SAVE.SHOWI, O_F_SAVE.SHOWJ, 0
FROM O_F_SAVE ,
COORDINATE
WHERE O_F_SAVE.SHOWI = COORDINATE.SHOWI AND
O_F_SAVE.SHOWJ = COORDINATE.SHOWJ AND DATEDIFF(MINUTE, '2000-9-5 10-2-32',
NEEDTIME) BETWEEN 30 AND 1410

[chao778899]

insert into dangank_byg(bianhao,xingming) select 12,'wq' where 12 not in (select distinct bianhao from dangank_byg)