How to pass value of a query in a variable?

Question

I want to pass the result of a query in a variable in sql server 2005 procedure. Please guide.

Rekha Singh · Answer

declare @var as nvarchar ( 50 ) set @var = ( select name from test where id = '1' ) print @var @var is a variable which will have the query result ********************************************* Pls mark Accepted if u find it helpful