<div>
Many thanks for the speedy reply - your code works a treat... &nbsp; 
</div>


Many thanks for the speedy reply - your code works a treat...  

<div>
<div class="content wysiwyg-content">
Hi there &nbsp;I'd like to be able to place the value returned from the command below into a varchar variable to use in a script but I am getting the error:<br />
<br />
Implicit conversion from data type sql_variant to varchar is not allowed. Use the CONVERT function to run this query.<br />
<br />
Ideally I'd like to have something like:<br />
<br />
DECLARE @server varchar(50)<br />
<br />
set @server = (select SERVERPROPERTY('MachineNam<wbr />e') WindowsServerName) &nbsp;whilst using the CONVERT function - can anyone help as I'm really new to TSQL programming.<br />
<br />
Thanks<br />
<br />

<pre><code id="code-315912">select SERVERPROPERTY('MachineName') WindowsServerName
</code></pre>
</div>
</div>


Hi there  I'd like to be able to place the value returned from the command below into a varchar variable to use in a script but I am getting the error:

Implicit conversion from data type sql_variant to varchar is not allowed. Use the CONVERT function to run this query.

Ideally I'd like to have something like:

DECLARE @server varchar(50)

set @server = (select SERVERPROPERTY('MachineName') WindowsServerName)  whilst using the CONVERT function - can anyone help as I'm really new to TSQL programming.

Thanks


Convert a sql_variant value to a varchar

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.