SQL Server Cheat Sheet
SQL Server Cheat Sheet
Dateparts
Year
Quarter
yy, yyyy
qq, q
System Data Types
bigint
binary
Month
Day of Year
Day
mm, m
dy, y
dd, d
bit
char
cursor
Week
Hour
wk, ww
hh
datetime
decimal
Minute
Second
mi, n
ss, s
float
image
Millisecond
ms
int
Day Of Week dw
Date Functions
DATEADD (datepart, number, date)
DATEDIFF (datepart, start, end)
DATENAME (datepart, date)
money
nchar
ntext
numeric
nvarchar
DATEPART (datepart, date)
real
DAY (date)
GETDATE ()
smalldatetime
smallint
GETUTCDATE ()
MONTH (date)
YEAR (date)
smallmoney
sql_variant
table
text
timestamp
Convert Date Style Codes
mon dd yyyy hh:miAM
100 (or PM)
101 mm\dd\yyyy
103 dd/mm/yy
120 yyyy-mm-dd hh:mi:ss
Convert(Datatype, Date, Style)
tinyint
varbinary
varchar
uniqueidentifier
xml
Date
Time
DateTime2
DateTimeOffset
Geometry
Geography
HierarchyId
-2^63 to 2^63-1
January 1, 1753, through
December 31, 9999
- 10^38 +1 through 10^38 - 1
8 Bytes
2 4 byte
integers
- 1.79E+308 to -2.23E-308, 0
and 2.23E-308 to 1.79E+308
-2^31 (-2,147,483,648) to 2^31-1
(2,147,483,647)
4 Bytes
-922,337,203,685,477.5808
to 922,337,203,685,477.5807 8 Bytes
Equiv. to decimal
- 3.40E + 38 to -1.18E - 38, 0
and 1.18E - 38 to 3.40E + 38
4 Bytes
(Equiv. to Float(24)
January 1, 1900, through June 2 2 byte
integers
6, 2079
-2^15 (-32,768) to 2^15-1 (32,767) 2 Bytes
- 214,748.3648 to
214,748.3647
4 Bytes
0 to 255
Mathematical
Functions
ABS
ACOS
String Functions
ASCII
CHAR
ASIN
ATAN
ATN2
CHARINDEX
DIFFERENCE
LEFT
CEILING
COS
LEN
LOWER
Aggregate Functions
AVG
COT
DEGREES
LTRIM
NCHAR
BINARY_CHECKSUM
CHECKSUM
EXP
PATINDEX
FLOOR
LOG
LOG10
PI
POWER
REPLACE
QUOTENAME
REPLICATE
REVERSE
RIGHT
RADIANS
RTRIM
SUM
RAND
ROUND
SOUNDEX
SPACE
STDEV
STDDEVP
SIGN
SIN
SQUARE
SQRT
TAN
STR
STUFF
SUBSTRING
UNICODE
UPPER
VAR
VARP
Ranking Functions
RANK
DENSE_RANK
Char. to find, String to
search, [start])
(Pattern, Expression)
(String, Substring,
Replacement)
NTILE
ROW_NUMBER
CHECKSUM_AVG
COUNT
COUNT_BIG
GROUPING
MAX
MIN
(String, Start, Length)
1 Byte
Syntax
row_number() over(order by [Column])
declare CursorName cursor local fast_forward
for
{Select}
Accurate to 100 nanoseconds 1/1/1 to 12/31/9999
open CursorName
fetch next from Diff_Cursor into @ColumnA, @ColumnB
while @@FETCH_STATUS = 0
begin
{Work}
fetch next from Diff_Cursor into @ColumnA, @ColumnB
end
close CursorName
deallocate CursorName
................
................
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
- working with the geodatabase effectively using sql
- native json datatype support maturing sql and nosql
- handbase data exchange for windows
- fixing problems with numeric text fields using the field
- lab manual cse 3200
- how to convert sql from the microsoft sql server database
- section 8 worksheet e r diagrams
- oracle to bigquery sql translation reference
- sql server cheat sheet cheat sheet all cheat sheets in
- a guide to f string formatting in python
Related searches
- sql server data classification
- sql server data classification tool
- sql server data types
- azure sql server hyperscale
- sql server 2016 string functions
- sql server connection strings
- sql server localhost connection string
- sample sql server connection string
- sql server trusted connection string
- sql server trusted connection true
- sql server connection string trusted connection
- connection string c sql server examples