Saturday, May 1, 2010

FORMATTING NUMBERS IN SQL

To format numbers in sql queries in SQL SERVER 2005, use the following command

Select Convert(nvarchar,cast(123123323 as money),1)

This will convert the following number 123123323 to 123,123,323.00

No comments:

Difference Between Apache Common Logging and Log4J

Dear Folks, Log4j is a logging framework, i.e. it provides the code to log messages while Commons-logging is an abstraction layer for log...