declare @VarName as [Schema].[Table].[Column]%Type
I would like to reuse a Variables type from a Columns Type. There would be no need to check the ColumnType anymore - and if a column is altered the Stored Proc should be recompiled.
Aaron Abdis commented
YES! Please. This is one of the (Very) few things I miss form the ORACLE world. It makes code VASTLY more maintainable, and is far superior to UDTs, since once a UDT is used, you can't alter it without removing all the uses first.
alex Neuhold commented
... I know I could define a Type - but this would be much more easier to change Code for existing systems