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.

2
  • 1
    You most probably don't want to use double (or float or real) anyway: floating-point-gui.de 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

This site is temporarily in read only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .