select * into #v from (select * from sddata where txndate <'2007-1-11')aEXEC master..xp_cmdshell 'bcp "tempdb.dbo.#v " out "c:\b.txt" /S"localhost" /U"sa" /P"sa" -c'服务器返回#v无效. 不知怎么能使用到临时表? thanks
实在不行,可以先创建一个临时表,用完后再删除create table V() insert into select * into V from (select * from sddata where txndate <'2007-1-11')aEXEC master..xp_cmdshell 'bcp "tempdb.dbo.v " out "c:\b.txt" /S"localhost" /U"sa" /P"sa" -c'drop table V
是不是又新建了一个连接,所以临时表就不存在了. 要么改成 select * into ##v from (select * from sddata where txndate <'2007-1-11')aEXEC master..xp_cmdshell 'bcp "tempdb.dbo.##v " out "c:\b.txt" /S"localhost" /U"sa" /P"sa" -c'
insert into select * into V from (select * from sddata where txndate <'2007-1-11')aEXEC master..xp_cmdshell 'bcp "tempdb.dbo.v " out "c:\b.txt" /S"localhost" /U"sa" /P"sa" -c'drop table V
要么改成
select * into ##v from (select * from sddata where txndate <'2007-1-11')aEXEC master..xp_cmdshell 'bcp "tempdb.dbo.##v " out "c:\b.txt" /S"localhost" /U"sa" /P"sa" -c'
这些参数什么意思了?没看明白