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#
Add new attachment
Only authorized users are allowed to upload new attachments.
«
This page (revision-3) was last changed on 30-Aug-2017 13:13 by BlakeMcBride
JSPWiki v2.10.4