But i want to store the values to destination from source which has the same size..
I cannot increase the size from (11, 5) to (15, 5) to match the datatype of Test..
SourceQuery:
select CONVERT(NUMERIC(11, 5), test) Name from sourcetable
DestinationTable:
columnname Type computed Length Precision scale
---------- ------------ ------------ --------- ---------- -------
DestTest numeric no 9 15 5