Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Sql_forum
Yak Posting Veteran
50 Posts |
Posted - 2012-07-20 : 08:29:46
|
HI,I want to store valure eturned from dynamic query execution into a variable and i dont want to return it...How can i achieve it??i tried some ways, but they didnt workcan anyone help me ??? |
|
sql-programmers
Posting Yak Master
190 Posts |
Posted - 2012-07-20 : 08:41:33
|
DECLARE @LocalVaribale AS VARCHAR(10)DECLARE @query AS NVARCHAR(4000) = ''SET @query = 'SELECT @Out = ''Test'' 'EXEC sp_executesql @query ,N'@Out varchar(10) output' , @Out = @LocalVaribale OUTPUTSELECT @LocalVaribaleSQL Server Programmers and Consultantshttp://www.sql-programmers.com/ |
|
|
|
|
|