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:33 am

    #1633547

    You can place this code as the first CASE statement:

    WHEN DATA_TYPE = 'decimal'

    THEN '(' + Cast(NUMERIC_PRECISION AS VARCHAR(5)) + ',' + Cast(NUMERIC_SCALE AS VARCHAR(5)) + ')'

    You can expand the CASE statement the same way for all other different datatypes...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **