MSSQL robust isnumeric() for try_cast test prior to 2012

better_isnumeric.sql

select
    @val as str_val
    ,case
        when isnumeric(@val + '.0e0') = 1 then
            case
                when convert(float, @val) between 0 and 255
                    then cast(@val as tinyint)
                else null
            end
        else null
    end as tinyint_val
    ,case
        when isnumeric(@val + '.0e0') = 1 then
            case
                when convert(float, @val) between -32768 and 32767
                    then cast(@val as smallint)
                else null
            end
        else null
    end as smallint_val
    ,case
        when isnumeric(@val + '.0e0') = 1 then
            case
                when convert(float, @val) between -2147483648 and 2147483647
                    then cast(@val as int)
                else null
            end
        else null
    end as int_val
    ,case
        when isnumeric(@val + '.0e0') = 1
            then cast(@val as bigint)
        else null
    end as bigint_val
    ,case
        when isnumeric(@val + 'e0') = 1
            then cast(@val as decimal(38, 10))
        else null
    end as dec_val