title: SQL Server : selecting multiple columns into multiple variables in a stored procedure
body: <p>The following works in MySQL:</p>
  
  <pre><code>DECLARE myInt INT(20);
  DECLARE myDate DATETIME;
  
  SELECT someInt, someDate
  INTO myInt, myDate
  FROM someTable
  WHERE myName = someName
  </code></pre>
  
  <p>Is it possible to do something like that in SQL Server?</p>
  
  <p>SQL Server complaints about "Incorrect syntax" in the <code>INTO</code> line f that is attempted local @variables.</p>