title: Is there a way to bind a variable type to column data type?
body: <p>In Oracle PL/SQL, you can always bind your code variables' type to a specific table.column type like this:</p>
  
  <pre><code>myVar TABLE.COLUMN%TYPE
  </code></pre>
  
  <p>So, if you change the column's type, you don't have to go over your code to re-define related var types (of course you'd still need to check you are properly using the variable).</p>
  
  <p>Is there a similar way to define this in SQL Server 2005?</p>