Click or drag to resize

SA0140 : Reserved keyword is not in the requried case

The topic describes the SA0140 analysis rule.

Message

Reserved keyword is not in the requried case

Description

The rule checks T-SQL code for reserved keywords which do not use the required keyword case.

The parameter RequiredCase specifies the required case for the keywords.

NOTE: The rule excludes reserved keywords in datatypes such as varchar, nvarchar, int and etc.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters
NameDescriptionDefault Value
RequiredCase

The parameter specifies the required case of the reserved keywords.

UPPERCASE

Remarks

The rule does not need Analysis Context or SQL Connection.

Categories

Naming Rules

Additional Information

There is no additional info for this rule.

Example Test Script
SQL
 1CREATE TABLE Test.Greeting
 2(
 3GreetingId INT identity (1,1) PRIMARY KEY,
 4Message nvarchar(255) NOT NULL,
 5)
 6
 7INSERT INTO Test.Greeting (Message) 
 8SELECT 'Hello!'
 9UNION ALL 
10SELECT 'Hi!'
11UNION ALL
12SELECT 'Hello, world!'
13
14insert into Test.Greeting (Message) 
15values ('How do yo do?'),
16        ('Good morning!'),
17        ('Good night!')
18
19DELETE  Test.Greeting wherE GreetingId = 3
20
21SELECT * FROM Test.Greeting g 
22where 
23g.Message like 'Hello%'
24
25drop TABLE Test.Greeting

Analysis Results

 MessageLineColumn
1SA0140 : Reserved keyword is not in the requried case.315
2SA0140 : Reserved keyword is not in the requried case.140
3SA0140 : Reserved keyword is not in the requried case.147
4SA0140 : Reserved keyword is not in the requried case.150
5SA0140 : Reserved keyword is not in the requried case.1922
6SA0140 : Reserved keyword is not in the requried case.220
7SA0140 : Reserved keyword is not in the requried case.2310
8SA0140 : Reserved keyword is not in the requried case.250
See Also

Other Resources