SQL SERVER 2012 T-SQL 新增特性-TRY_CONVERT
SQL SERVER 2012 T-SQL 新增函数-TRY_CONVERT，非常耗用。看一个例子：
declare @numerics as table
( row_id tinyint identity(1,1) primary key, numeric_val varchar(100))
insert into @numerics(numeric_val)values('35.2'),(' 100.7(received tylenol per RN'),('120'),('100.6(@4pm)'),('92.4 orally'),('37.2(99.0)'),('35.3 C'),('-97.6')
select n.numeric_val,try_convert(float, n.numeric_val) as nv_try_convert,isnumeric(n.numeric_val) as nv_isnumeric, case
when try_convert(float, n.numeric_val) is not null
then abs(try_convert(float, n.numeric_val))
when left(ltrim(n.numeric_val),4) like '.'
then abs(try_convert(float, left(ltrim(n.numeric_val),4)))
when left(ltrim(n.numeric_val),5) like '.'
then abs(try_convert(float, left(ltrim(n.numeric_val),5))) end as nv_try_convert_case
from @numerics n
页:
[1]