isnumeric

SQL code

select case when isnumeric(a)=1 and a>11.0 then 1 else 0 end  from # --Error converting data type varchar to numeric.

SQL code

select case when  a>11.0 then 1 else 0 end from #where isnumeric(a)=1
[解决办法]
探讨

SQL code

select case when  a>11.0 then 1 else 0 end 
from #
where isnumeric(a)=1

[解决办法]
select case when cast(a as decimal(18,1))>11.0 then 1 else 0 end from # where isnumeric(a)=1

[解决办法]
a字段什么类型？
[解决办法]
select case when cast(a as decimal(18,1))>11.0 then 1 else 0 end from # where isnumeric(a)=1

select case when isnumeric(a)=1 and cast(a as decimal(18,1))>11.0 then 1 else 0 end from #  

[解决办法]
select case when a>11.0 then 1 else 0 end from # where isnumeric(a)=1
[解决办法]
SQL code
CREATE TABLE #(a NVARCHAR(10))INSERT # SELECT 1INSERT # SELECT 'a'INSERT # SELECT '.'--isnumeric(a)=1INSERT # SELECT ','--isnumeric(a)=1goselect isnumeric(a),case when (isnumeric(a)=1 AND a NOT LIKE '%[,]%' AND a<>'.')and cast(a as decimal(18,1))>11.0 then 1 else 0 end from #  DROP TABLE #
[解决办法]
探讨

SQL code
CREATE TABLE #(a NVARCHAR(10))

INSERT # SELECT 1
INSERT # SELECT 'a'
INSERT # SELECT '.'--isnumeric(a)=1
INSERT # SELECT ','--isnumeric(a)=1

go

select isnumeric(a),case when (isn……