I have table column with specification Decimal(10,3).This is my query
declare @p2 dbo.InvoiceItemType
insert into @p2 values(N'b68f0118-83de-48cb-8799-beefa5b44a72',N'612',N'',N'P.V.C. Transparent Hose 1/2" X 1/8" W.T.',NULL,N'95.00',N'0.00',N'11.875000',N'12.321',NULL,NULL,N'201403014',NULL,N'1',N'1',N'1',N'1',N'1/2" X 1/8" W.T.',N'4')
exec spUpdateInvoiceById @Id='65F394C1-2EF4-4CAA-9FBC-C02AE27AA7F8',@ProductTable_TVP=@p2,@ExtraCharge_TVP=@p3,@InvoiceDate='2014-03-18 00:00:00',@BuyerOrderNo=N'13',@DispatchedThrough=N'85',@Destination=N'',@DispatchDocumentNo=N'95',@ModifiedBy=1,@IsCSTApplicable=0,@MainCopy=0
After this query is executed properly I used select to get the records but when I see result I got '12.320' instead of '12.321'