27,579
社区成员
发帖
与我相关
我的任务
分享
select * from tb where isnumeric(str_jg)=0
select cast('0.39' as float)
union
select cast('50' as float)
declare @c1 varchar(10),@c2 varchar(10),@c3 varchar(10)
select @c1='3',@c2='3.14',@c3='3.14E-5'
select cast(@c1 as float),cast(@c2 as float),cast(@c3 as float)
/*
---------------------- ---------------------- ----------------------
3 3.14 3.14E-05
(1 行受影响)
*/