<div>
&gt; I want to be able to display a message <br />
where?<br />
<br />
I guess that you only want this:<br />
<br />
print 'CheckIt value is: ' + cast(@checkit as vachar(20))
</div>


> I want to be able to display a message
where?

I guess that you only want this:

print 'CheckIt value is: ' + cast(@checkit as vachar(20))

<div>
select &quot;CheckIt value is: &quot;&nbsp;+ @CheckIt
</div>


<div>
Do you mean something like this<br />
<br />
PRINT 'CheckIt value is:' + Convert(Varchar(10),@Check<wbr />It)
</div>


Do you mean something like this

PRINT 'CheckIt value is:' + Convert(Varchar(10),@CheckIt)

<div>
<div class="content wysiwyg-content">
Hi. &nbsp;I have a variable named @CheckIt. &nbsp;I want to be able to display a message saying &quot;CheckIt value is: &quot;&nbsp; followed by the value in the variable. Does anyone know how to code this in SQL Server?
</div>
</div>


Hi.  I have a variable named @CheckIt.  I want to be able to display a message saying "CheckIt value is: "  followed by the value in the variable. Does anyone know how to code this in SQL Server?

How to display a message in SQL Server

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.