Friday 19 August 2011

What Is SQL?

SQL: Data Types

The following is a list of general SQL datatypes that may not be supported by all relational databases.
Data Type
Syntax
Explanation (if applicable)
integer
integer

smallint
smallint

numeric
numeric(p,s)
Where p is a precision value; s is a scale value. For example, numeric(6,2) is a number that has 4 digits before the decimal and 2 digits after the decimal.
decimal
decimal(p,s)
Where p is a precision value; s is a scale value.
real
real
Single-precision floating point number
double precision
double precision
Double-precision floating point number

more>>>>>

No comments:

Post a Comment