There is a reserved keyword DOUBLE in SQL Server, but I know that it's not a data type (other languages' double is float or real in SQL Server); does anyone know why this is a keyword?

I've tried to use it in SQL Server 2008 and SQL Server 2012 and I cannot use it as a data type nor a function and I cannot find any info in MSDN pages; only that it is a reserved keyword and it isn't a data type.

  • 1
    You most probably don't want to use double (or float or real) anyway: floating-point-gui.de
    – user1822
    Commented Jun 9, 2015 at 12:42
  • We usually use DECIMAL in SQL Server, but sometimes we're limited from third party Databases that use floats instead. Asking for DOUBLE was only to know why it was reserved keyword :)
    – AJuez
    Commented Jun 9, 2015 at 13:51

1 Answer 1


This is actually part of the DOUBLE PRECISION type, synonym of float(53).


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.