select * into ##tmp from ckb
EXEC master..xp_cmdshell 'bcp ##tmp in E:\万泰\db\ckb.txt -c -q -S"cgq" -U"sa" -P"sa"'
select * from ##tmp
drop table ##tmp
或:
select * into ##tmp from ckb
EXEC master..xp_cmdshell 'bcp tempdb.dbo.##tmp in E:\万泰\db\ckb.txt -c -q -S"cgq" -U"sa" -P"sa"'
select * from ##tmp
drop table ##tmp
select * into ##tmp from ckb
EXEC master..xp_cmdshell 'bcp tempdb.dbo.#tmp in E:\万泰\db\ckb.txt -c -q -S"cgq" -U"sa" -P"sa"'
select * from ##tmp
drop table ##tmp
select * into ##tmp from ckb
EXEC master..xp_cmdshell 'bcp wt.dbo.#tmp in E:\万泰\db\ckb.txt -c -q -S"cgq" -U"sa" -P"sa"'
select * from ##tmp
drop table ##tmp
select * into #tmp from ckb
EXEC master..xp_cmdshell 'bcp wt.dbo.#tmp in E:\万泰\db\ckb.txt -c -q -S"cgq" -U"sa" -P"sa"'
select * from #tmp
drop table #tmp