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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 storing result from dynamic qry execution

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 work

can 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 OUTPUT

SELECT @LocalVaribale

SQL Server Programmers and Consultants
http://www.sql-programmers.com/
Go to Top of Page
   

- Advertisement -