title: SQL Select a row and store in a SQL variable
body: <p>So, I'm writing this Stored Proc and I really suck at SQL.</p>
  
  <p>My Question to you guys is:</p>
  
  <p><b>Can I select an entire row and store it in a variable?</b></p>
  
  <p>I know I can do something like:</p>
  
  <pre><code>declare @someInteger int
  select @someInteger = (select someintfield from sometable where somecondition)
  </code></pre>
  
  <p>But can I select the entire row from <code>sometable</code> and store it in a variable?</p>