22,302
社区成员




BULK INSERT test.dbo.[TB_1]
FROM 'C:\Documents and Settings\Administrator\桌面\123.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n' ,
TABLOCK
)
insert into table1(a,b,c,e)
select 'a','3ab','tad','d3d3'
union
select '3','dks','sie','d33d'
......
--> 类似这样的:
if object_id('tempdb.dbo.#T') is not null drop table #T
create table #T (C1 varchar(11),C2 varchar(11),C3 varchar(11),C4 varchar(11))
insert into #T
select 'a','3ab','tad','d3d3' union all
select '3','dks','sie','d33d' union all
select '3','3edff','csd','3ded'
select C1,C2,C3,C4 from #T
/*
C1 C2 C3 C4
----------- ----------- ----------- -----------
a 3ab tad d3d3
3 dks sie d33d
3 3edff csd 3ded
*/
insert into ta(a,b,c)
select 'a','3ab','tad','d3d3' union all
select 'a','3ab','tad','d3d3' union all
select 'a','3ab','tad','d3d3'.............