title: T-SQL equivalent of PL/SQL %TYPE?
body: <p>Is there any equivalent to %TYPE in MSSQL2005?</p>
  
  <pre><code>CREATE TABLE TEST (ID NUMBER(5));
  
  DECLARE
  myVar TEST.ID%TYPE;
  BEGIN
  ................
  END;
  </code></pre>