Post reply

Decimal vs Numeric

  • February 8, 2013 at 4:34 am

    #288998

    hi,

    What is the difference between these two data types?

    I have read like, we have these two for backward compatibility. What does it means? These two are available since sql server 6.5, Then what is the backward compatibility here?

    🙂

  • February 8, 2013 at 4:47 am

    #1585867

    No difference. One is synonym for the other, cant remember which one.

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths

  • February 8, 2013 at 1:49 pm

    #1586136

    In SQL Server, there is no difference.

    I guess the backward compatability would be that you can still use "numeric" rather than the offical "decimal".

    SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply