declare @i int declare @sql nvarchar(1000) set @i=0select id=identity(int,1,1),* into [NewTable] from [Table] order by [Field]while @i<=100000/1000 begin set @sql='bcp "select * from db.dbo.[NewTable] where id between "'+ltrim(@i*1000+1)+' and '+ltrim((@i+1)*1000)+' queryout "d:\test'+ltrim(@i)+'.txt" -c -Sserver -Uuser -Ppassword' exec master..xp_cmdshell @sql set @i=@i+1 end
declare @sql nvarchar(1000)
set @i=0select id=identity(int,1,1),* into [NewTable] from [Table] order by [Field]while @i<=100000/1000
begin
set @sql='bcp "select * from db.dbo.[NewTable] where id between "'+ltrim(@i*1000+1)+' and '+ltrim((@i+1)*1000)+' queryout "d:\test'+ltrim(@i)+'.txt" -c -Sserver -Uuser -Ppassword'
exec master..xp_cmdshell @sql
set @i=@i+1
end