Ispirer Website Ispirer Capabilities - Microsoft SQL Server Migration Free Trial

SQL Server Data Types - FLOAT

Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5

SQL Server - FLOAT
Syntax FLOAT[(p)]
Data Floating-point numeric data
Parameters p specifies the precision in binary digits
Range 1E-308 to 1E+308, 1 ⇐ p ⇐ 53
Default p is 53
Storage Size 4 bytes if p ⇐ 24, 8 bytes if p > 24
Standards ANSI SQL

SQL Server FLOAT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle FLOAT(p)
MySQL FLOAT(p,s)
PostgreSQL FLOAT(p)
Sybase ASE FLOAT(p)
Informix FLOAT(p), p is ignored
HP Neoview FLOAT(p)
Ingres FLOAT

Related Data Types in SQL Server

Data Types
Integers BIGINT INT SMALLINT TINYINT
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point REAL DOUBLE PRECISION

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.