you dont need to do this change in table. This is a presentation requirement which should be done at your front end application. Application languages have set of formatting functions build in to perform these tasks
Trying to implement this in SQL is ugly as it would require datatype conversions which will cause unwanted overheads when you use this data for manipulations like sorting,comparison etc
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
you dont need to do this change in table. This is a presentation requirement which should be done at your front end application. Application languages have set of formatting functions build in to perform these tasks
Trying to implement this in SQL is ugly as it would require datatype conversions which will cause unwanted overheads when you use this data for manipulations like sorting,comparison etc
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Thanks for your quick reply.
As of now we are doing it application level. But few issues we are not able to find until build moved to prodction since staging server is with "en-US" as defult and working perfect. To avoid these issue I want to change configuration of SQL SERVER Instance. I have tried it changing collation property(exactly production server database collation) of Database by recreating and restore DB option, still issue remains same.
what are those issues? can you illustrate? Changing collation wont change existing data. it will only affect newly added data.
So far as your base fields are numeric datatypes i don't think so you'll face any issues in comparing them regardless of their formats. The issue can happen only when you do processing outside of sql server ie in application or at front end
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
How to change decimal format dot(.) to comma(,) in
Posted - 02/07/2013 : 06:04:29
