title: Declaring variable type based on a column type
body: <p>In Oracle's PL-SQL, you can declare a variable and define its type based on a table column:</p>
  
  <pre><code>declare var1 table.column%TYPE;
  </code></pre>
  
  <p>Is it possible to do something similar in MS SQL Server?</p>