In Sql Server Express
I need use in field MONEY
"update product set price='1,23' where cod='001'"
i don′t use
"update product set price='1.23' where cod='001'"
hi,
with all kind of datatypes supporting fixed or non fixed decimal values you have to use the "." as decimal separator... so you have to code
UPDATE ... SET price = 1.23 WHERE...
and this without the " quote for the value...
regards
No comments:
Post a Comment