HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

SQL Server DOUBLE keyword

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqlkeyworddoubleserver

Problem

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.

Solution

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

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

Context

StackExchange Database Administrators Q#103582, answer score: 8

Revisions (0)

No revisions yet.