<div>
declare @user nvarchar(50)<br />
select @user = value from mytable<br />
select @user<br />

</div>


declare @user nvarchar(50)
select @user = value from mytable
select @user


<div>
there's another way. in QA you you can output &nbsp;to 'messages' not 'grids'
</div>


there's another way. in QA you you can output  to 'messages' not 'grids'

<div>
<br />
declare @user nvarchar(50)<br />
select @user = value from mytable<br />
print @user<br />
<br />
itsvtk<br />

</div>



declare @user nvarchar(50)
select @user = value from mytable
print @user

itsvtk


<div>
In that case, use print like itsvtk said.
</div>


In that case, use print like itsvtk said.

<div>
declare @user nvarchar(50)<br />
select @user = value from mytable<br />
print @user<br />
<br />
sorry didn't see this. thanks
</div>


declare @user nvarchar(50)
select @user = value from mytable
print @user

sorry didn't see this. thanks

<div>
<div class="content wysiwyg-content">
i use something like:<br />
<br />
declare @user nvarchar(50)<br />
set @user = select value from mytable<br />
<br />
how do I then print the value of @user to the screen. I've seen it done but can't remember how.
</div>
</div>


i use something like:

declare @user nvarchar(50)
set @user = select value from mytable

how do I then print the value of @user to the screen. I've seen it done but can't remember how.

how to print value of variable

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.