version ---------------------------------------------------------- Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2) sum --------------------------------------- 0.1 2005 下是0.1
select @@version /* ------------------------------------------------------------------------------------------------------------------------------ Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2) (1 行受影响) */select sum(1.5-1.4) /* --------------------------------------- 0.1(1 行受影响) */--======================================================================== select @@version /* ----------------------------------------------------------- Microsoft SQL Server 2000 - 8.00.2273 (Intel X86) Mar 7 2008 22:19:58 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) (所影响的行数为 1 行) */select sum(1.5-1.4) /*
/*
0.1
*/
select sum(1.5-1.4)
/*
----------------------------------------
.1
*/
select convert(varchar,sum(1.5-1.4))
0.1(1 行受影响)
这个应该没有太大关系吧
想变成.1还变不出来
你用的是什么版本?
/*
------
0.1(所影响的行数为 1 行)
*/
/*
------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
(1 行受影响)
*/select sum(1.5-1.4)
/*
---------------------------------------
0.1(1 行受影响)
*/
如
select .1*100
select 0.1*100
结果相同数值0.XX 在SQL2000默认值里是 .XX, SQL2005中估计开发人员与注意到这个细节, 默认值成 0.XX形式
----------------------------------------------------------
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
sum
---------------------------------------
0.1
2005 下是0.1
不就是返回0.1吗?
开始-->设置-->控制面板-->区域和语言选项-->自定义-->零起始显示
这样还是不行的只有在前台用 select format(sum(1.5-1.4),"###,##") 处理了
两步走:
1.开始-->设置-->控制面板-->区域和语言选项-->自定义-->零起始显示-->(把.7调整为0.7就行了.)
2.在查询分析器菜单栏选择[工具]-->[选项]-->[连接]-->钩选[在显示货币、号码、日期和时间时使用区域设置]
/*
------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
(1 行受影响)
*/select sum(1.5-1.4)
/*
---------------------------------------
0.1(1 行受影响)
*/--========================================================================
select @@version
/*
-----------------------------------------------------------
Microsoft SQL Server 2000 - 8.00.2273 (Intel X86)
Mar 7 2008 22:19:58
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
(所影响的行数为 1 行)
*/select sum(1.5-1.4)
/*
----------------------------------------
.1(所影响的行数为 1 行)
*/