查询结果保存到文件

exec master..xp_cmdshell 'bcp "Select * from JXT.dbo.[Orders2]" queryout "d:\tt.txt" -c -t, -U sa -P 123456'

go