Friday, March 9, 2012

Decimal Separator with Comma... is Possible?

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