sql server new users: Hi,

i defined a field as 'money' (and then as 'smallmoney').
When i insert a non integer value in that field, it's rounded: e.g. if i
insert 17,95, it becomes 18,0000 in the table.
Any way to prevent That?

thanks
michel

That shouldn't be happening. I'm using the US period separator but I see
this:
CREATE TABLE T1
(ColMoney money,
ColSmallMoney smallmoney)
GO
INSERT T1(ColMoney, ColSmallMoney)
VALUES (17.9567, 17.9567)
GO
SELECT * FROM T1
GO

Result set:
ColMoney ColSmallMoney
--------------------- ---------------------
17.9567 17.9567

(1 row(s) affected)

How are you entering the data? Perhaps it is being converted to an int
before the insert.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]