SQL Server语言设置 [英] Sql Server Language Settings

问题描述

区域设置会影响sql server吗?
正在将说1.5的值保存到DB
保存为1,5
有什么想法吗?

请通知我


当我通过查询分析器插入时，显示为1,5


因此，以下计算出错了

is regional settings affect sql server?
am saving a value say 1.5 to DB
its saving as 1,5
any idea regarding this?

Please inform me


When i insert via query analyser,its showing 1,5


because of this,the following calculation is going wrong

推荐答案

不是.

保存值时，SQL Server并不关心区域设置，这是软件的表示层执行的.如果您的PC设置为将小数点指示器显示为，"，则所有Windows应用程序通常都会执行该操作.没关系:无论如何，该值都将保存为一个半值.

It isn''t.

SQL server does not care about regional settings when saving values, it is the presentation layer of your software that does that. If your PC is set to show the decimal point indicator as a '','' then all windows apps will normally do that. It doesn''t matter: the value will be saved as one-and-a-half regardless.

这篇关于SQL Server语言设置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！