存储执行语句的变量返回值 [英] store Value in variable return by execute statement
本文介绍了存储执行语句的变量返回值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
声明 @ value varchar ( 500 )
声明 @ Whrcol varchar ( 500 )
声明 @ Whrvalue varchar ( 500 )
set @ Whrcol = ' Product Cat3'
set @ Whrvalue = ' < span class =code-string> IR DOME CAMERA'
set @value =( ' 从tblProductsCatalog中选择[表名],其中[' + @ Whrcol + ' ] =''' + @ Whrvalue + ' ''')
执行( @ value )
我想通过Execute语句保存值返回,以便我可以在下一个语句中使用
即
执行('select * from'+ @ value +',其中IsActive = 1')
得到错误....
我怎么能这样做
我试用几个小时但是无法解决
请帮助
解决方案
要获得价值,请使用:
声明 @ value varchar ( 500 )
声明 @ Whrvalue varchar ( 500 )
set @ Whrvalue = ' IR DOME CAMERA'
SELECT @value = [表名称]
FROM tblProductsCatalog
WHERE [Product Cat3] = @ Whrvalue
SELECT @ value AS [表名称]
好的,如果你想建立动态查询并获取此查询返回的值,请参阅:
http://stackoverflow.com/questions/803211/how-to-get-sp-executesql-result-into-a-variable [ ^ ]
[/编辑]
您好
试试这....
声明 @ value varchar ( 500 )
声明 @ Whrcol varchar ( 500 )
声明 @ Whrvalue varchar ( 500 )
声明 @ TableDtls 表(TableName VARCHAR ( 500 ))
set @ Whrcol = ' Product Cat3'
set @ Whrvalue = ' IR DOME CAMERA'
set @value =(' 从tblProductsCatalog中选择[表名],其中[' + @ Whrcol + ' ] ='' ' + @ Whrvalue + ' ''')
INSERT INTO @ TableDtls (TableName)
执行( @ value )
SELECT TableName FROM @ TableDtls
问候,
GVPrabu
在 选择语句表 name.Take 列名称。
声明 @ value varchar ( 500 )
声明 @Whrcol varchar ( 500 )
声明 @ Whrvalue varchar ( 500 )
set @ Whrcol = ' 产品Cat3'
set @ Whrvalue = ' IR DOME CAMERA'
set @value =(' 从tblProductsCatalog中选择[Column Name],其中[' + @ Whrcol + ' ] =''' + @ Whrvalue + ' ' '')
执行( @ value )
declare @value varchar(500)
declare @Whrcol varchar(500)
declare @Whrvalue varchar(500)
set @Whrcol='Product Cat3'
set @Whrvalue='IR DOME CAMERA'
set @value=('select [Table Name] from tblProductsCatalog where ['+ @Whrcol+ '] ='''+@Whrvalue+'''')
execute (@value)
I want to save the value return by Execute statement so that i can use in next statement
i.e.
execute('select * from '+@value+ ' where IsActive =1')
getting error....
How can i do it
im trying from several hours but not able to solve
please help
解决方案
To get value, use this:
declare @value varchar(500) declare @Whrvalue varchar(500) set @Whrvalue='IR DOME CAMERA' SELECT @value=[Table Name] FROM tblProductsCatalog WHERE [Product Cat3]= @Whrvalue SELECT @value AS [Table Name]
[EDIT]
OK, if you want to build dynamic queries and get value returned by this query, see this:
http://stackoverflow.com/questions/803211/how-to-get-sp-executesql-result-into-a-variable[^]
[/EDIT]
Hi
Try This....
declare @value varchar(500) declare @Whrcol varchar(500) declare @Whrvalue varchar(500) declare @TableDtls TABLE(TableName VARCHAR(500)) set @Whrcol='Product Cat3' set @Whrvalue='IR DOME CAMERA' set @value=('select [Table Name] from tblProductsCatalog where ['+ @Whrcol+ '] ='''+@Whrvalue+'''') INSERT INTO @TableDtls(TableName) execute (@value) SELECT TableName FROM @TableDtls
Regards,
GVPrabu
In select statement you have taken Table name.Take Column name. declare @value varchar(500) declare @Whrcol varchar(500) declare @Whrvalue varchar(500) set @Whrcol='Product Cat3' set @Whrvalue='IR DOME CAMERA' set @value=('select [Column Name] from tblProductsCatalog where ['+ @Whrcol+ '] ='''+@Whrvalue+'''') execute (@value)
这篇关于存储执行语句的变量返回值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文