SQL Server - Cheat Sheet

SQL Server Data Types Exact Numerics bit decimal tinyint money smallint numeric bigint Appr­oximate Numerics float real Date and Time smalld­atetime      timestamp datetime Stri­ngs char text varchar Unicode Strings nchar ntext nvarchar Binary Strings binary image varbinary Misc­ell­ane­ous cursor table sql_va­riant xml SQL Server Type Conversion CAST (expre­ssion AS datatype) CONVERT (datatype, expres­sion) SQL Server Table Functions ALTER DROP CREATE               TRUNCATE

SQL Server Grouping (Aggregate) Functions AVG BINARY­_CH­ECKSUM MAX MIN CHECKSUM SUM STDEV CHECKS­UM_AVG COUNT COUNT_BIG STDEVP VAR VARP GROUPING SQL Server Ranking Functions RANK NTILE DENSE_RANK ROW_NUMBER SQL Server String Functions ASCII REPLICATE CHAR REVERSE CHARINDEX RIGHT DIFFERENCE     RTRIM LEFT SOUNDEX LEN SPACE LOWER STR LTRIM STUFF NCHAR SUBSTRING PATINDEX UNICODE REPLACE UPPER QUOTENAME

SQL Server Date Functions DATEADD (datepart, number, date) DATEDIFF (datepart, start, end) DATENAME (datepart, date) DATEPART (datepart, date) DAY (date) GETDATE() GETUTC­DATE() MONTH (date) YEAR (date) SQL Server Dateparts yy, yyyy    Year qq, q Quarter mm, m Month dy, y Day of Year dd, d Day wk, ww Week hh Hour mi, n Minute ss, s Second ms Millis­econd SQL Server Mathematical Functions ABS LOG10 ACOS PI ASIN POWER ATAN RADIANS ATN2 RAND CEILING ROUND COS SIGN COT SIN DEGREES    SQUARE EXP SQRT FLOOR TAN LOG