SQL Workshop - Washington University in St. Louis
SQL Workshop
Data Types
Doug Shook
Data Types
Four categories ? String ? Numeric ? Temporal ? Other
26 types total
2
Numeric Types
The integer data types
Type bigint int smallint tinyint bit
Bytes 8 4 2 1 1
The decimal data types
Type decimal[(p[,s])] numeric[(p[,s])] money 8 smallmoney
Bytes 5-17 5-17
4
The real data types
Type float[(n)] real
Bytes 4 or 8 4
3
Numeric Types
Decimal data types include precision and scale ? Precision: total number of digits ? Scale: number of digits to the right of decimal
Integer and decimal types are exact ? Real data types include a small amount of error
4
String Types
String data types for storing standard characters
Type char[(n)] varchar[(n)]
Bytes n
String data types for storing Unicode characters
Type nchar(n) nvarchar(n)
Bytes 2?n
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- sql server cheat sheet
- how to convert sql from the microsoft sql server database
- migrating mysql to sql server 2014 and azure sql db
- sql workshop washington university in st louis
- entity attribute value eav the antipattern too great to
- vfp conversion to support sql server backend
- azure data warehouse as a service dwaas
- here is the crib sheet study notes i used for the three
- sql server data type conversion chart
- t sql data types
Related searches
- university city st louis mo
- colleges in st louis missouri
- schools in st louis mo
- universities in st louis mo
- places to eat in st louis mo
- best school districts in st louis mo
- top school districts in st louis county
- clinics in st louis mo
- private schools in st louis area
- best school districts in st louis area
- things to do in st louis missouri
- what is open in st louis mo