<div>
declare @mail varchar(50)<br />
<br />
select @mail=email from parent where username=@parentname<br />
<br />
select @mail
</div>


declare @mail varchar(50)

select @mail=email from parent where username=@parentname

select @mail

<div>
you are sure about that your query will return only one value so there is no problem at all, since there is no concept like array in SQL Server so if your query will return more than one row in above query, only last email address will be stored in @mail variable.
</div>


you are sure about that your query will return only one value so there is no problem at all, since there is no concept like array in SQL Server so if your query will return more than one row in above query, only last email address will be stored in @mail variable.

<div>
generally in the situation Author has, I would go for SELECT not for SET, nothing much different but just wanted to stick with ANSI standard, basically SET is used to assign static value and SELECT is for getting value in variable from QUERY. have a look.<br />
<br />
<a href="http://www.sqlhub.com/2009/03/set-and-select-in-sql-server-2005.html" rel="ugc">http://www.sqlhub.com/2009/03/set-and-select-in-sql-server-2005.html</a><br />

</div>


generally in the situation Author has, I would go for SELECT not for SET, nothing much different but just wanted to stick with ANSI standard, basically SET is used to assign static value and SELECT is for getting value in variable from QUERY. have a look.

http://www.sqlhub.com/2009/03/set-and-select-in-sql-server-2005.html [http://www.sqlhub.com/2009/03/set-and-select-in-sql-server-2005.html]


<div>
<div class="content wysiwyg-content">
hi .. let's say i have a table and a variable. <br />
<br />
SELECT email from parent where username = @pusername; &nbsp;<br />
<br />
will return the value that i need to have in @mail variable.. <br />
<br />
how can i set the @mail variable to get the value of the above sql query ? i also know that it will return only one result . <br />
thanks in advance 
</div>
</div>


hi .. let's say i have a table and a variable. 

SELECT email from parent where username = @pusername;  

will return the value that i need to have in @mail variable.. 

how can i set the @mail variable to get the value of the above sql query ? i also know that it will return only one result . 
thanks in advance 

MSSQL how to get value from table into 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.

Microsoft SQL Server

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.

Microsoft SQL Server 2005

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.