T-SQL's equivalent of Oracle's %TYPE opera

问题:

When writing a procedure in PL/SQL, I can declare a parameter's type as myTable.myColumn%TYPE so that when I alter myColumn's type from say varchar2(20) to varchar2(50) I don't have to change the procedure's parameter type. Is there something similar in T-SQL?

回答1:

No, there is no equivalent in T-SQL.

回答2:

The best that you could do would be to create a user-defined data type, then you could change the underlying UDT and it would take effect in both places.

This would affect it everywhere that you use it, so if you used the type in multiple tables it would affect them all if you changed it.