mssql sqlserver Between and 怎么包含科学计数的数据


摘要:
下文分享sql脚本编写中,如何对科学计数法的数字使用between and关键字,如下所示:
实验环境:sqlserver 2008 R2

 /*
Between and 怎么包含科学计数的数据
*/
create table test(keyId float,info varchar(10))
go
insert into test(keyId,info)values(1123244.01,'a')
insert into test(keyId,info)values(12424232323323333333333334555.014545,'b')
insert into test(keyId,info)values(8952324424.0241,'C')
insert into test(keyId,info)values(986522242442.088,'d') 
go

select * from test 
where keyId 
  between  1.24E+28  and 5.62E+29 
 
go
truncate table test 
drop table test
mssql_sqlserver_between_and用法简介

mssql_sqlserver_between_and用法简介