求一SQL语句?

[long7411]

当表中某一记录不存在时,则插入一条记录

我用以下写的都不行,该怎么写,谢谢了!:
if not exists (select * from dbo.datatxt where 时间='20070615'and 序号= '00000473')
insert into dbo.datatxt values ('20070615','082020594','00000473','+107.96383','+18.93985','-043.357','0','2','+012.752','000000.838','000000.078','002.330','004','004','002','003','001')

insert into dbo.datatxt values ('20070615','082020594','00000473','+107.96383','+18.93985','-043.357','0','2','+012.752','000000.838','000000.078','002.330','004','004','002','003','001') WHERE not exists (select * from dbo.datatxt where 时间='20070615'and 序号= '00000473')

[昵称被占用了]

第二种应该改成

insert into dbo.datatxt select '20070615','082020594','00000473','+107.96383','+18.93985','-043.357','0','2','+012.752','000000.838','000000.078','002.330','004','004','002','003','001' WHERE not exists (select * from dbo.datatxt where 时间='20070615'and 序号= '00000473')

[昵称被占用了]

可能数据类型有问题吧

需要表结构

[long7411]

已按上说的修改通过！

[you_tube]

楼上正确!

[hellowork]

第一种方法应该没问题,如果有问题则可能是values()中指定的值的数量与表中列的数量不一致,
请把datatxt表的结构帖出来.
第二中方法语法错误.