4

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 – a_horse_with_no_name Jun 9 '15 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 Jun 9 '15 at 13:51
9

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

https://msdn.microsoft.com/en-us/library/ms173773.aspx

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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