SQL Server Cheat Sheet - Cheat Sheet : All Cheat …
Data Types
Exact Numerics
Date Functions
Create a Stored Procedure
DATEADD (datepart, number, date)
CREATE PROCEDURE name
bit
decimal
DATEDIFF (datepart, start, end)
tinyint
money
DATENAME (datepart, date)
smallint
bit
DATEPART (datepart, date)
numeric
DAY (date)
int
bigint
GETDATE ()
int
GETUTCDATE ()
Approximate Numerics
float
YEAR (date)
SELECT * FROM table
timestamp
Dateparts
Create a Trigger
Date and Time
smalldatetime
-- Comments
GO
MONTH (date)
real
@variable AS datatype = value
AS
CREATE TRIGGER name
ON
datetime
table
Strings
char
text
varchar
Unicode Strings
nchav
ntext
nvarchar
Binary Strings
binary
image
varbinary
Miscellaneous
cursor
table
sql_variant
xml
Year
yy, yyyy
Quarter
qq, q
Month
mm, m
Day of Year
dy, y
Day
dd, d
Week
wk, ww
Hour
hh
Minute
mi, n
Second
ss, s
Millisecond
ms
FOR
DELETE, INSERT, UPDATE
AS
-- Comments
SELECT * FROM table
GO
Create a View
CREATE VIEW name
AS
Mathematical Functions
-- Comments
SELECT * FROM table
Type Conversion
CAST (expression AS datatype)
CONVERT (datatype, expression)
Ranking Functions
ABS
LOG10
ACOS
PI
ASIN
POWER
ATAN
RADIANS
ATN2
RAND
CREATE UNIQUE INDEX name
CEILING
ROUND
ON
COS
SIGN
COT
SIN
RANK
NTILE
DENSE_RANK
DEGREES
ROW_NUMBER
SQUARE
EXP
SQRT
FLOOR
TAN
Grouping (Aggregate) Functions
AVG
Create an Index
table (columns)
Create a Function
CREATE FUNCTION name
LOG
(@variable datatype(length))
RETURNS
MAX
BINARY_CHECKSUM MIN
CHECKSUM
SUM
String Functions
ASCII
REPLICATE
CHECKSUM_AVG
STDEV
CHAR
REVERSE
COUNT
STDEVP
CHARINDEX
RIGHT
COUNT_BIG
VAR
DIFFERENCE
RTRIM
GROUPING
VARP
LEFT
SOUNDEX
LEN
SPACE
LOWER
STR
Table Functions
GO
datatype(length)
LTRIM
STUFF
ALTER
DROP
NCHAR
SUBSTRING
CREATE
TRUNCATE
PATINDEX
UNICODE
REPLACE
UPPER
QUOTENAME
AS
BEGIN
DECLARE @return datatype(length)
SELECT @return = CASE @variable
WHEN 'a' THEN 'return a'
WHEN 'b' THEN 'return b'
ELSE 'return c'
RETURN @return
END
Available free from
................
................
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 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