how would I asign values received from a query to variables

[belcom125]

Say if I do a "select top 1 id, name from table" just to get one record, how can I asign the values retrieved from that query to variables @id and @name in a SQL 2000 stored procedure?

 

[dbomrrsm]

Declare the variables then use the SET command:

set @id = (Select....)

[blue]DBomrrsm[/blue]

 

[belcom125]

that is one variable, but I have multiple like "@id, @name, etc" from same query

 

[SQLSister]

Select @test= field1, @test2 = field2 from table1 where field3 = 'test'

Questions about posting. See faq183-874

 

[maswien]

you should be able to do it using:

select top 1 @id = id, @name = name from employee