错误 = [Microsoft][SQL Server 本机客户端 11.0][SQL Server]对象名称'#HashTable'无效

Question

以下是错误，我正在从#哈希表数据中获取选择查询，但无法将其输出到txtfile

output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL
Starting copy...
SQLState = S0002, NativeError = 208
Error = [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name '#HashTable'.
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 11.0]Unable to resolve column level collations
NULL
BCP copy out failed
NULL

Select * from #TempData
DECLARE @OutputFile NVARCHAR(100) ,    @FilePath NVARCHAR(100) ,    @bcpCommand NVARCHAR(1000)

SET @bcpCommand = 'bcp "SELECT * FROM #HashTable" queryout '
SET @FilePath = 'C:test'
SET @OutputFile = 'FileName1.txt'
SET @bcpCommand = @bcpCommand + @FilePath + @OutputFile + ' -c -t, -T -S'+ @@servername
exec master..xp_cmdshell @bcpCommand

Answer 1

#HashTable是一个临时表，必须在当前会话中创建。

例如：

--Create your own temp table named  #HASHTABLE
Select Id , Name 
INTO #HASHTABLE
From ExistingTable ;
Select * from #HashTable;

Drop Table #HashTable;

有关更多信息，请参阅此链接