我有一文本,现在想追加到A数据库的B表中(该文本已经满足表B 的格式)需要满足的条件是:对N字段的重复记录不追加,请问怎样写语句 ------------------ 先将数据导入C表. 然后:insert into B select * from C where N not in (select N from C)------------------------- 或是自己写代码逐一进行判断后再导入数据.
create table a( a varchar(50), b varchar(50) ) go BULK INSERT a FROM 'c:\stu.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) go select * from a go drop table a go c盘下有 stu.txt文件 1,数据1 2,数据2 3,数据3
------------------
先将数据导入C表.
然后:insert into B select * from C where N not in (select N from C)-------------------------
或是自己写代码逐一进行判断后再导入数据.
create table a(
a varchar(50),
b varchar(50)
)
go
BULK INSERT a
FROM 'c:\stu.txt'
WITH (
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
go
select * from a
go
drop table a
go
c盘下有
stu.txt文件
1,数据1
2,数据2
3,数据3