22,210
社区成员
发帖
与我相关
我的任务
分享
BCP "SELECT * FROM dbName.dbo.tableName" queryout c:/User.txt -F 50000 -L 100000-c -U"sa" -P"password" --第50000条到10000条记录
Select row_number() over(order by getdate()) no,* into #tb from dbname..tablename
while @i<24
set @str='EXEC master..xp_cmdshell ''bcp "Select * from #tb where no
between '+rtrim(@i)+' and '+rtrim((@i+1)*50000)+'" queryout c:\DT.txt'+rtrim(@i)+
' -c -Sservername -Usa -Ppassword'''
exec(@str)
EXEC master..xp_cmdshell 'bcp "Select * from dbname..tablename" queryout c:\DT.txt -c -Sservername -Usa -Ppassword'