decimal delimiter: comma / dot

  • Thread starter Thread starter B D Jensen
  • Start date Start date
B

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
 
B said:
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
Click to expand...

Control Panel -> Regional options
Customize
 
B D Jensen said:
I forgot to write:

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

The Command Prompt is also controlled by the Regional Settings mentioned by
VanguardLH. What exactly are you trying to achieve in the Command Prompt?
 
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...
 
B said:
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...
Click to expand...

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?
 
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
 
Back
Top