SQL Select a row and store in a SQL variable

Viewed 47299

So, I'm writing this Stored Proc and I really suck at SQL.

My Question to you guys is:

Can I select an entire row and store it in a variable?

I know I can do something like:

declare @someInteger int
select @someInteger = (select someintfield from sometable where somecondition)

But can I select the entire row from sometable and store it in a variable?

3 Answers
Related