decimal point in SQL-server2000 / decimal comma in SQL-server2008

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105712 More actions · Answer 1

As far as I know it's not possible to force the use of comma as decimal separator in T-SQL code.

You can use it in SSMS to display data.

-- Gianluca Sartori

jan.nooitgedagt Old Hand Points: 320 More actions · Answer 2

Thanks for answering so quick !

Is it neither possible to configure it when installing the server and/or database ?

( by the way: what does ssms stand for )

spaghettidba SSC Guru Points: 105712 More actions · Answer 3

I don't think it's possible.

SSMS stands for SQL Server Management Studio, the client tool used for queries and management.

-- Gianluca Sartori

jan.nooitgedagt Old Hand Points: 320 More actions · Answer 4

Thanks so far !

Maybe someone can explain the difference between 2000 and 2008.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 5

Here is one method of showing a decimal value in the format you requested.

DECLARE @v DECIMAL(18,4)

SET @v =10001.5768

SELECT REPLACE(convert(nvarchar(15), cast(@V as money), 2),'.',',')

Result:

10001,5768

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

jan.nooitgedagt Old Hand Points: 320 More actions · Answer 6

Thank you !

When i dont have any other posibility i will use this.