Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to get correct datatype names for numeric and date type values RE: How to get correct datatype names for numeric and date type values

  • July 18, 2013 at 1:23 am

    #1633546

    Hi,

    I tried with this logic also,But this time it is showing datatype as numeric but it is not showing value(range.like numeric(38))Here we can refer numeric_precision to get that '38' as range value

    DATA_TYPE

    + CASE

    WHEN CHARACTER_MAXIMUM_LENGTH IS NULL

    THEN ''

    WHEN Cast(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(5)) = - 1

    THEN '(Max)'

    ELSE '(' + Cast(CHARACTER_MAXIMUM_LENGTH AS VARCHAR(5)) + ')'

    END AS [Type]