decimal delimiter: comma / dot

[B D Jensen]

Hi!
Can I change some setting such that
for my current session(! e.g. not other users)
the decimal operator will be switched?

I want to be able to switch between
1234,56
1234.56

Best Regards
Bjorn D. Jensen

 

[VanguardLH]

Hi!
Can I change some setting such that
for my current session(! e.g. not other users)
the decimal operator will be switched?

I want to be able to switch between
1234,56
1234.56

Best Regards
Bjorn D. Jensen

Control Panel -> Regional options
Customize

 

[B D Jensen]

I forgot to write:

I want to work it within an dosprompt (e.g. cmd)...

 

[Pegasus \(MVP\)]

I forgot to write:

I want to work it within an dosprompt (e.g. cmd)...

The Command Prompt is also controlled by the Regional Settings mentioned by
VanguardLH. What exactly are you trying to achieve in the Command Prompt?

 

[B D Jensen]

I want to run sqlcmd, but sqlcmd has no options for changing decimal
seperator.
And there is no SET command in TSQL for this purpose.
So I try to change the settings for the "client", e.g. the cmd
session...

 

[VanguardLH]

I want to run sqlcmd, but sqlcmd has no options for changing decimal
seperator.
And there is no SET command in TSQL for this purpose.
So I try to change the settings for the "client", e.g. the cmd
session...

So why aren't you asking in a SQL newsgroup on how to specify the format
of numeric fields in the records in your database?

 

[B D Jensen]

I also did about the tools provided by SQL Server;
but it seems they miss some flags :-0

I ask here, because I try to solve from another corner:
the environment settings ;-)
Best Regards
Bjorn D. Jensen