如何用變量得到查詢結果？

[奔跑9999]

SQL Code

declare @SQLResult varchar(30)

declare @datafield varchar(30)

declare @sql varchar(800)



set @datafield='PropertyID50'

set @sql='Select Top 1 '+ @datafield +' From tblItemProp Where ItemPropID=19229'

exec (@sql)



set @SQLResult= exec (@sql) --為何這句不能執行。

[liangCK]

3. 输出参数 
declare @num int, 
        @sqls nvarchar(4000) 
set @sqls='select count(*) from tableName' 
exec(@sqls) 
--如何将exec执行结果放入变量中？ 

declare @num int, 
               @sqls nvarchar(4000) 
set @sqls='select @a=count(*) from tableName ' 
exec sp_executesql @sqls,N'@a int output',@num output 
select @num 

[sdhdy]

declare @SQLResult  varchar(30) 

declare @datafield varchar(30) 

declare @sql nvarchar(800) 



set @datafield='PropertyID50' 

set @sql=N'Select Top 1 @SQLResult='+ @datafield +'  From tblItemProp Where ItemPropID=19229' 
exec sp_executesql @sql,N'@SQLResult varchar(30) output',@SQLResult output
select @SQLResult

[guguda2008]

[Quote=引用 1 楼 liangck 的回复:]
SQL code3. 输出参数declare@numint,@sqlsnvarchar(4000)set@sqls='select count(*) from tableName'exec(@sqls)--如何将exec执行结果放入变量中？declare@numint,@sqlsnvarchar(4000)set@sqls='select @a=count(*) from tableName'ex¡­
[/Quote]
学习

[feixianxxx]

[Quote=引用 1 楼 liangck 的回复:]
SQL code3. 输出参数declare@numint,@sqlsnvarchar(4000)set@sqls='select count(*) from tableName'exec(@sqls)--如何将exec执行结果放入变量中？declare@numint,@sqlsnvarchar(4000)set@sqls='select @a=count(*) from tableName'ex¡­
[/Quote]
梁哥 那 是不是要改下。。

declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from tableName '
exec sp_executesql
@sqls,
N'@a int output',
@num=@a output
select @num

[SQL77]

CREATE TABLE TB(STRING VARCHAR(2000))
INSERT TB  exec (@sql)
SELECT @SQLResult=STRING FROM TB