Sql Server Cheat Sheet
ADVERTISEMENT
1SQL Server Cheat Sheet
by
Dave Child (DaveChild)
via
SQL Server Data Types
SQL Server Grouping (Aggre g ate) Functions
SQL Server Dateparts
Exact Numerics
AVG
MAX
yy, yyyy
Year
bit
decimal
BINARY _ CH E CKSUM
MIN
qq, q
Quarter
tinyint
money
CHECKSUM
SUM
mm, m
Month
smallint
numeric
CHECKS U M_AVG
STDEV
dy, y
Day of Year
bigint
COUNT
STDEVP
dd, d
Day
Appr o ximate Numerics
COUNT_BIG
VAR
wk, ww
Week
float
real
GROUPING
VARP
hh
Hour
Date and Time
mi, n
Minute
SQL Server Ranking Functions
smalld a tetime
timestamp
ss, s
Second
RANK
NTILE
datetime
ms
Millis e cond
DENSE_RANK
ROW_NUMBER
Stri n gs
SQL Server Mathem a tical Functions
char
text
SQL Server String Functions
ABS
LOG10
varchar
ASCII
REPLICATE
ACOS
PI
Unicode Strings
CHAR
REVERSE
ASIN
POWER
nchar
ntext
CHARINDEX
RIGHT
ATAN
RADIANS
nvarchar
DIFFERENCE
RTRIM
ATN2
RAND
Binary Strings
LEFT
SOUNDEX
CEILING
ROUND
binary
image
LEN
SPACE
COS
SIGN
varbinary
LOWER
STR
COT
SIN
Misc e ll a ne o us
LTRIM
STUFF
DEGREES
SQUARE
cursor
table
NCHAR
SUBSTRING
EXP
SQRT
sql_va r iant
xml
PATINDEX
UNICODE
FLOOR
TAN
REPLACE
UPPER
SQL Server Type Conversion
LOG
QUOTENAME
CAST (expre s sion AS datatype)
CONVERT (datatype, expres s ion)
SQL Server Date Functions
DATEADD (datepart, number, date)
SQL Server Table Functions
DATEDIFF (datepart, start, end)
ALTER
DROP
DATENAME (datepart, date)
CREATE
TRUNCATE
DATEPART (datepart, date)
DAY (date)
GETDATE()
GETUTC D ATE()
MONTH (date)
YEAR (date)
By Dave Child (DaveChild)
Published 19th October, 2011.
Sponsored by
Last updated 1st June, 2014.
Measure your website readability!
Page 1 of 1.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education