SDU Tools 131 Determining the thousands and decimal separator for a SQL Server session using T SQL
SDU Tools are free tools and example T-SQL code for SQL Server developers and DBAs. CurrentSessionDecimalSeparator is a simple function that works out what the decimal separator is. This is really useful if you are trying to manipulate numbers as strings, and aren't sure what the correct format should be. For example, Germany uses a comma as a decimal separator. CurrentSessionThousandsSeparator does the same for the character used to separate thousands.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com