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