Data TypeExact Numerics | bit | decimal | tinyint | money | smallint | numeric | bigint | Approximate Numerics | float | real | Date and Time | smalldatetime | timestamp | datetime | Strings | char | text | varchar | Unicode Strings | nchar | ntext | nvarchar | Binary Strings | binary | image | varbinary | Miscellaneous | cursor | table | sql_variant | xml |
String FunctionsASCII | REPLICATE | CHAR | REVERSE | CHARINDEX | RIGHT | DIFFERENCE | RTRIM | LEFT | SOUNDEX | LEN | SPACE | LOWER | STR | LTRIM | STUFF | NCHAR | SUBSTRING | PATINDEX | UNICODE | REPLACE | UPPER | QUOTENAME |
Type ConversionCAST (exression AS datatype) | CONVERT (datatype, expression, [style]) |
| | Grouping (Aggregate) FunctionsAVG | MAX | BINARY_CHECKSUM | MIN | CHECKSUM | SUM | CHECKSUM_AVG | STDEV | COUNT | STDEVP | COUNT_BIG | VAR | GROUPING | VARP |
Date FunctionsDATEADD (datepart, number, date) | SYSDATETIME() | DATEDIFF (datepart, start, end) | SYSUTCDATETIME() | DATENAME (datepart, date) | SYSDATETIMEOFFSET() | DATEPART (datepart, date) | SWITCHOFFSET (DATETIMEOFFSET,time_zone) | DAY (date) | ISDATE (expression) | GETDATE() | MONTH (date) | GETUTCDATE() | YEAR (date) |
Mathematical FunctionsABS | LOG10 | ACOS | PI | ASIN | POWER | ATAN | RADIANS | ATN2 | RAND | COT | SIN | TAN | EXP | COS | DEGREES | LOG | CEILING | ROUND | FLOOR | SQRT | SQUARE | SIGN |
| | DatepartsYear | 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 |
Object OperationStored Procedure
CREATE PROCEDURE <name> AS <sql_statement>
Views
CREATE VIEW<name>[(<Column>,...)]
AS <SELECT_statement>
Triggers
CREATE TRIGGER <name> ON <table>
FOR INSERT, UPDATE, DELETE AS <sql_statement>
Functions
CREATE FUNCTION <name>
RETURNS <data_type>
AS BEGIN <sql_statement>
RETURN <sql_expression> END
|
Create a Stored ProcedureCREATE PROCEDURE name
@variable AS datatype = value
AS
-- Comments
SELECT * FROM table
GO
|
Ranking FunctionsRANK | NTILE | DENSE RANK | ROW_NUMBER |
| | Foreign Key ConstructALTER TABLE <table1> WITH CHECK
ADD CONSTRAINT <constraintName>
FOREIGN KEY (<table1col1>)
REFERENCES <table2> (<table2col2>)
|
Drop ConstraintALTER TABLE <tablename> DROP
CONSTRAINT <constraintName>
|
Primary Key constructALTER TABLE <tablename> ADDCONSTRAINT <constraintName>
PRIMARY KEY CLUSTERED (column_List)
|
Create an IndexCREATE UNIQUE INDEX name
ON
table (columns)
|
T-SQL StatementsUPDATE Statement
UPDATE table_name
SET column_name=(expression | DEFAULT | NULL [,...n]
[WHERE <search_condition>]
DELETE Statement
DELETE [FROM] table_name
[WHERE <search_condition>]
INSERT Statement
INSERT [INTO] table_name [(column_list)]
VALUES ((DEFAULT | NULL | expression 1[,...n])
|
Select Statement ConstructSELECT [DISTINCT] [(TOP int | TOP int PERCENT)]
Column list
[INTO new_table]
FROM table_source
[[[INNER | {{ LEFT | RIGHT | FULL}[OUTER]}] JOIN | CROSS APPLY]
table_source2
ON table_source.primary_key =
table_source2.foreign_key][,...n]
[WHERE search_condition]
[GROUP BY group_by_expression]
[HAVING search_condition]
[ORDER BY order_expression [ASC | DESC]]
|
|
Created By
Metadata
Favourited By
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets
More Cheat Sheets by danar124