title: Setting multiple scalar variables from a single row in SQL Server 2008?
body: <p>In a trigger, I have code like:</p>
  
  <pre><code>SET @var1 = (SELECT col1 FROM Inserted);
  SET @var2 = (SELECT col2 FROM Inserted);
  </code></pre>
  
  <p>Is it possible to write the above in a single line? Something conceptually like:</p>
  
  <pre><code>SET (@var1,@var2) = (SELECT col1,col2 FROM Inserted);
  </code></pre>
  
  <p>Obviously I tried the above, without success; am I just stuck with the first method?</p>
  
  <p>Even if possible, is that a good idea?</p>
  
  <p>Thanks!</p>