Skip to content

Instantly share code, notes, and snippets.

@sqlparser
sqlparser / Capitalization function name
Created April 9, 2014 02:15
Capitalization function name
SELECT DEPARTMENT_ID,
Min(SALARY)
FROM employees
GROUP BY DEPARTMENT_ID
@sqlparser
sqlparser / Capitalization column name
Created April 9, 2014 02:15
Capitalization column name
SELECT DEPARTMENT_ID,
Min( SALARY )
FROM employees
GROUP BY DEPARTMENT_ID
@sqlparser
sqlparser / Capitalization table name
Created April 9, 2014 02:14
Capitalization table name
SELECT department_id,
Min( salary )
FROM EMPLOYEES
GROUP BY department_id
@sqlparser
sqlparser / Capitalization prefixed identifier
Created April 9, 2014 02:13
Capitalization prefixed identifier
SELECT *
FROM fn_virtualfilestats(DB_ID(N'AdventureWorks2012'), 2);
@sqlparser
sqlparser / Capitalization quoted identifier
Created April 9, 2014 02:12
Capitalization quoted identifier
SELECT [department_id],
Min( [salary] )
FROM [employees]
GROUP BY [department_id]
@sqlparser
sqlparser / Capitalization general identifier
Created April 9, 2014 02:10
Capitalization general identifier
SELECT department_id,
Min( salary )
FROM employees
GROUP BY department_id
@sqlparser
sqlparser / Capitalization datatype
Created April 9, 2014 01:56
Capitalization datatype
CREATE TABLE dept(deptno NUMBER(2),
dname VARCHAR2(14),
loc VARCHAR2(13))
@sqlparser
sqlparser / Capitalization keywords
Created April 9, 2014 01:55
Capitalization keywords
SELECT department_id,
Min( salary )
FROM employees
GROUP BY department_id
@sqlparser
sqlparser / indentation if block with begin end
Created April 9, 2014 01:49
indentation if block with begin end
IF @cost <= @compareprice BEGIN
PRINT 'These products can be purchased for less than '
END
ELSE
PRINT 'The prices for all products in this category exceed '
@sqlparser
sqlparser / indentation if block without begin end
Created April 9, 2014 01:48
indentation if block without begin end
IF (x < 7) THEN
IF (y < 0) THEN
<statements>
END IF;
ELSIF (x > 10) THEN
<statements>
ELSE
<statements>
END IF;