SQL Server - GUARDAR CON DECIMALES

CREATE TABLE dbo.MyTable

(

  MyDecimalColumn DECIMAL(5,2)

,MyNumericColumn NUMERIC(10,5)

);

GO

INSERT INTO dbo.MyTable VALUES (123, 12345.12);

GO

SELECT MyDecimalColumn, MyNumericColumn

FROM dbo.MyTable;

MyDecimalColumn                         MyNumericColumn

--------------------------------------- ---------------------------------------

123.00                                  12345.12000

(1 row(s) affected)