-
Notifications
You must be signed in to change notification settings - Fork 13
SQL capitalization identifier
Tako Lee edited this page Feb 20, 2014
·
39 revisions
Set identifier to preferred case option.
```SQL
SELECT department_id,
Min( salary )
FROM employees
GROUP BY department_id
```
-
Quoted identifier
SELECT [department_id], Min( [salary] ) FROM [employees] GROUP BY [department_id]
-
Prefixed identifier
Prefixed identifier is user defined identifier. For example, you can define identifier start with fn_ as SQL Server system function. This format option apply to all prefixed identifiers.
SELECT * FROM fn_virtualfilestats(DB_ID(N'AdventureWorks2012'), 2);