Showing posts with label serverlanguagebrazilian. Show all posts
Showing posts with label serverlanguagebrazilian. Show all posts

Friday, March 9, 2012

Decimal Separator in SQL Server with Comma... is possible?

In Brazil decimal separator=comma

SQL SERVER

LANGUAGE=BRAZILIAN OR PORTUGUESE

PRICE=MONEY

"UPDATE PRO SET PRICE='1,11' WHERE COD='0001'"

PRICE=111.00

all aplications use comma... impossible alter all!

Programmatically in SQL you will need to use a dot insted of a comma but the data can be displayed in the front using a comma provided you have the correct regional settings on the front end.