<div>
declare @variable varchar(100) <br />
SELECT @Variable = url <br />
from urtable <br />
Where &nbsp;
</div>


declare @variable varchar(100)
SELECT @Variable = url
from urtable
Where  

<div>
<div class="content wysiwyg-content">
Ok I've been trying various different ways of doing this all day but with no luck.<br />
<br />
I need to get a URL string from my MSSQL database,this string needs to be converted to a variable.<br />
<br />
How can i use my SQL query that will product one result (a string) then put that result into a variable?<br />
<br />
Thanks! This seems like such a simple issue to resolve but has given me such grief..
</div>
</div>


Ok I've been trying various different ways of doing this all day but with no luck.

I need to get a URL string from my MSSQL database,this string needs to be converted to a variable.

How can i use my SQL query that will product one result (a string) then put that result into a variable?

Thanks! This seems like such a simple issue to resolve but has given me such grief..

SQL query returning one value into variable

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

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.