系统:win7、windows 2008
64bit
数据库:
Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services 客户端工具 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft 数据访问组件 (MDAC) 6.1.7600.16385 (win7_rtm.090713-1255)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4927
操作系统 6.1.7600
运行以下代码:
declare @t1 float
declare @t2 float
select @t1=0.22,@t2=1.1
set @t2 = @t2*0.2
if(@t1<>@t2)
begin
select @t1,@t2
end
else
begin
select 2
end
运行出来结果是:
(无列名) (无列名)
0.22 0.22
其它类型如money就没有问题。
64bit
数据库:
Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services 客户端工具 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft 数据访问组件 (MDAC) 6.1.7600.16385 (win7_rtm.090713-1255)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4927
操作系统 6.1.7600
运行以下代码:
declare @t1 float
declare @t2 float
select @t1=0.22,@t2=1.1
set @t2 = @t2*0.2
if(@t1<>@t2)
begin
select @t1,@t2
end
else
begin
select 2
end
运行出来结果是:
(无列名) (无列名)
0.22 0.22
其它类型如money就没有问题。