!!! Microsoft SQL Server

!Data Types

| tinyint | 1 unsigned
| smallint | 2
| int | 4
| bigint | 8
| real | 4
| float | 8
| char(n) | 8K max
| varchar(n) | 8K max
| text | 2GB max
| image | binary
| date |
| datetime | deprecated, use datetime2
| datetime2 | | not null default (getdate())
| datetimeoffset | datetime with timezone
| timestamp | deprecated, use rowversion
| rowversion | sequential counter


!!!Auto-increment column:  mycol int not null identity

!!TSQL is a proprietary procedural language used by Microsoft in SQL Server