<div>
This is the best solution i got through EE ever.. it was so quick and spot on.. i really appreciate that
</div>


This is the best solution i got through EE ever.. it was so quick and spot on.. i really appreciate that

<div>
remarks: if you don't need dynamic sql, don't use dynamic sql!<br />
but I guess that you simplified your example in that regards :)
</div>


remarks: if you don't need dynamic sql, don't use dynamic sql!
but I guess that you simplified your example in that regards :)

<div>
<div class="content wysiwyg-content">
HI <br />
<br />
It is something similar to this i am trying to do<br />
<br />
declare @query nvarchar(500) ,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @value int<br />
<br />
set @query ='select count(*) from table_a'<br />
<br />
i want to assign the count to @value &nbsp;with sp_executesql<br />
<br />
How can i do this<br />
<br />
Thanks
</div>
</div>


HI 

It is something similar to this i am trying to do

declare @query nvarchar(500) ,
            @value int

set @query ='select count(*) from table_a'

i want to assign the count to @value  with sp_executesql

How can i do this

Thanks

getting values from sp_executesql

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.