Create a Stored Procedure CREATE PROCEDURE name @variable AS datatype = value AS --Comments SELECT * FROM table GO 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 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 Date Functions DATEADD (datepart, number, date) DATEDIFF (datepart, start, end) DATENAME (datepart, date) DATEPART (datepart, date) DAY (date) GETDATE () GETUTCDATE () MONTH (date) YEAR (date) Grouping (Aggregate) Functions AVG BINARY_CHECKSUM CHECKSUM CHECKSUM_AVG COUNT COUNT_BIG GROUPING MAX MIN SUM STDEV STDEVP VAR VARP Type Conversion CAST (expression AS datatype) CONVERT (datatype, expression) Data Types Exact Numerics bit tinyint smallint int bigint int Approximate Numerics float Date and Time smalldatetime datetime Strings char varchar Unicode Strings nchav nvarchar Binary Strings binary varbinary Miscellaneous cursor sql_variant decimal money bit numeric real timestamp text ntext image table xml Ranking Functions RANK DENSE_RANK NTILE ROW_NUMBER 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 Table Functions ALTER CREATE DROP TRUNCATE Create a Trigger CREATE TRIGGER name ON table FOR DELETE, INSERT, UPDATE AS --Comments SELECT * FROM table GO Available free from www.ILoveJackDaniels.com 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