-
Notifications
You must be signed in to change notification settings - Fork 13
SQL capitalization identifier
Tako Lee edited this page Mar 11, 2014
·
39 revisions
Set identifier to preferred case option. > Option: fmt102_case_identifier = lower, type: TFmtCase.
```SQL
SELECT department_id,
Min( salary )
FROM employees
GROUP BY department_id
```
-
Quoted identifier
Option: fmt103_case_quoted_identifier = lower, type: TFmtCase.
SELECT [department_id], Min( [salary] ) FROM [employees] GROUP BY [department_id]
-
Prefixed identifier
Option: fmt104_case_prefixed_identifier = lower, type: TFmtCase.
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);