Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

isqlw results number format

  
   Database Help (Home) -> Programming RSS
Next:  Need Trigger to Update Field  
Author Message
ionFreeman

External


Since: Mar 07, 2007
Posts: 10



(Msg. 1) Posted: Thu Oct 26, 2006 11:09 am
Post subject: isqlw results number format
Archived from groups: microsoft>public>sqlserver>programming (more info?)
Hi!
I did something to the Query Analyzer, and now all of my numbers
(including integers) are formatted #,###.00. That is, every number has
a decimal point (after which all integers show '00') and every number
at least 1000 has a comma four positions away.
How did I do this? How can I undo it?
Thanks!
Ion

 >> Stay informed about: isqlw results number format 
Back to top
Login to vote
ionFreeman

External


Since: Mar 07, 2007
Posts: 10



(Msg. 2) Posted: Thu Oct 26, 2006 12:09 pm
Post subject: Re: isqlw results number format [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks, Tibor & Arnie. Who knew people in my region liked their
integers with trailing zeroes?

Tibor Karaszi wrote:
> Possibly defined Regional option in one of the Tools, Options tabs...

 >> Stay informed about: isqlw results number format 
Back to top
Login to vote
Tibor Karaszi

External


Since: Jan 29, 2004
Posts: 1559



(Msg. 3) Posted: Thu Oct 26, 2006 8:20 pm
Post subject: Re: isqlw results number format [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Possibly defined Regional option in one of the Tools, Options tabs...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


wrote in message
> Hi!
> I did something to the Query Analyzer, and now all of my numbers
> (including integers) are formatted #,###.00. That is, every number has
> a decimal point (after which all integers show '00') and every number
> at least 1000 has a comma four positions away.
> How did I do this? How can I undo it?
> Thanks!
> Ion
>
 >> Stay informed about: isqlw results number format 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
question about number format - I want to format the following numbers 189800 to $190K 2501000 to $2,501K I used the following query (not sure what other way I can do) but the problem is I don't know how to add comma. is there an easier way to format the numbers in query? SELEC...

format number with thousand-separator - is there a built in function in sql server 2005 that will format a number with commas as the thousand-separator? ie., here's what i want to do: input=1000 output=1,000 or input=1000000 output=1,000,000 if there isn't a built-in function, can someone....

ISQLW OSQL SCLCMD ? - Hi I am building an, NSIS based, install CD ROM for my company's application. This includes the creation of a database. Until now that we had only sql server 2000 customers and I was using isqlw to run the sqls from command line Now our boss decided to..

query gives out different results - Hi, I did post a similar question yesterday - but it seems to have disappeared from view, so appologies if you have seen this before. I originally had a program which I sas told to put into a stored procedure. I have done this BUT, to check that it's...

How to get reverse results - I have a query that gets results based on several factors, and I want to get the reverse of that. For instance, my query is something like this: Select * from tblclients where fname like 'victor%' and lname like 'San%' How do I reverse that so I get....
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]