Question

是否有办法实现这一目标:

CREATE TABLE #TempLocal (tmpBanner nvarchar(255) )
SET @Query =  INSERT INTO #TempLocal (tmpBanner) SELECT TOP 1 F1 FROM  + @dbTable_Dollar
SELECT @Banner = tmpBanner FROM #TempLocal
DROP TABLE #TempLocal;
SELECT @Banner

基本上,我有动态的表参数,我需要从第1栏第1行获得价值。

感谢

KS

SOLUTION

DECLARE @Banner nvarchar(255),
@chvSQL NVARCHAR(300)

SELECT @chvSQL = N SELECT TOP 1 @Banner = [F1] from  +@dbTable_Dollar
EXEC sp_executesql @chvSQL, N @Banner varchar(50) OUTPUT , @Banner OUTPUT

Answer 1

Solution

DECLARE @Banner nvarchar(255),
@chvSQL NVARCHAR(300)

SELECT @chvSQL = N SELECT TOP 1 @Banner = [F1] from  +@dbTable_Dollar
EXEC sp_executesql @chvSQL, N @Banner varchar(50) OUTPUT , @Banner OUTPUT

Answer 2

You can put the result of your dynamic query on your temp table:

CREATE TABLE #TempLocal (tmpBanner nvarchar(255) )
SET @Query =  SELECT TOP 1 F1 FROM  + @dbTable_Dollar

INSERT INTO #TempLocal (tmpBanner)
EXEC(@Query)

SELECT @Banner = tmpBanner FROM #TempLocal

虽然我建议你研究

SOLUTION

Solution

友情链接