Data-Type mapping in SQL server 2005

Question

Is there a way to declare mapped data-types in SQL Server 2005, something like Oracle's %Type:

Declare a emp.sal%type where data-type of a will be same as sal field of emp table

or Declare a emp%rowtype where data-types of a will be same as each row of emp table.

I have googled it,but couldn't find it.

Answer 1

The Oracle %TYPE attribute adapts code as table definitions change. If the column's type changes, the variable adapts to use the correct type during run time. This enables data independence without requiring to know the exact data types to be assigned for a variable or database column.

Microsoft SQL Server does NOT support and has no equivalent of Oracle %TYPE.