在临时表中声明查询 [英] Declare Query in Temptable

问题描述

在Sql Server的Temp表中声明查询.

例如.

  DECLARE   @ cols   VARCHAR (最大值)
选择  @ cols  = 凉粉( @ cols  + ' ，[' + [名称] + ' ] INT'，'  [' + [名称] + ' ] INT')
 FROM  CaseTypeMaster

选择  @ cols  然后在结果下方显示
[与员工相关]  INT ，[与客户相关]  INT ，[HR相关]  INT 

我想动态地将插入到的 插入范围
 DECLARE   @ TempTable   AS  表([与员工相关]  INT ，[与客户相关]  INT ，[HR相关]  INT ，[申诉补救]  INT )

 DECLARE   @ TempTable   AS  表格( @ cols )

 是否可能或 不是吗? pre> 





有谁知道解决方案吗?



在@TempTable列中显示CaseTypeMaster表记录.
解决方案
 
 
  INSERT   INTO   @ TempTable (columnName)
选择 *  FROM   @ cols  
 
 
 
Declare Query in Temp table in Sql Server.



E.g. 

DECLARE @cols VARCHAR (MAX)      
SELECT @cols = COALESCE (@cols + ',[' + [Name] + '] INT', '[' + [Name] + '] INT')      
FROM    CaseTypeMaster      

Select  @cols then display below result 
[Employee Related] INT,[Customer Related] INT,[HR Related] INT,[Grievance Redressal] INT

which i want to insert dynamically into temptable parameter   
DECLARE @TempTable AS TABLE ([Employee Related] INT,[Customer Related] INT,[HR Related] INT,[Grievance Redressal] INT)

DECLARE @TempTable AS TABLE (@cols) 

It is possible or not ?
 





Any one to know the solution ?



Display CaseTypeMaster  table record display in   @TempTable Column.
解决方案
INSERT INTO @TempTable (columnName)
SELECT * FROM @cols


                        
这篇关于在临时表中声明查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！