--创建表
USE [Test]
GO
CREATE TABLE [dbo].[AccountYh](
[id] [int] NULL,
[Account] [nvarchar](200) NULL,
[Other] [nvarchar](2000) NULL
) ON [PRIMARY]
--------
SP_CONFIGURE 'show advanced options',1
GO
RECONFIGURE
GO
sp_configure 'xp_cmdshell',1
GO
RECONFIGURE
GO
-------执行,注意修改@i(文件最大值),文件路径,插入的表名
declare @sql nvarchar(2000),@i int
select @sql='',@i=10
while @i>0 begin
set @sql='
Bulk insert [Test].[dbo].[AccountYh]
from ''D:\Visual Studio\test\logslis_'+convert(varchar,@i)+'.txt''
with
(
FIELDTERMINATOR = '':'',
ROWTERMINATOR = ''\n'',
MAXERRORS=100
)'
exec(@sql)
set @i=@i-1
end