SA0261 : The number of characters per line should not exceed the configured value

The topic describes the SA0261 analysis rule.

Message

The number of characters per line should not exceed the configured value

Description

The rule checks SQL code and reports lines, which have more characters than the maximum number of line characters specified by the MaximumLineLength rule parameter.

How to fix

Break the line at possible position in order not exceed the number of line characters specified by the MaximumLineLength rule parameter.

Scope

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

Parameters
Name Description Default Value
MaximumLineLength

Maximum number of characters per line.

120
Remarks

The rule does not need Analysis Context or SQL Connection.

Effort To Fix
2 minutes per issue.
Categories

Design Rules, Code Smells

Additional Information

There is no additional info for this rule.

Example Test SQL
SQL
Copy
 1CREATE TABLE SA0261.Greeting 
 2( 
 3    GreetingId INT IDENTITY (1,1) PRIMARY KEY, Message nvarchar(255) NOT NULL, 
 4)
 5
 6INSERT INTO SA0261.Greeting (Message) VALUES ('How do yo do?'), ('Good morning!'), ('Good day!'), ('Good evening!'), ('Good night!')
 7
 8-- this line is not so long comment with more than 100 characters per line.
 9-- this line is a very long and has more than 100 characters, which should trigger a rule violation when the MaximumLineLength parameter has value > 100.
10
11DELETE  SA0261.Greeting WHERE GreetingId = 3
Analysis Results
  Message Line Column
1 The number of characters per line should not exceed the configured value. 6 0
2 The number of characters per line should not exceed the configured value. 9 0
See Also

Other Resources

Analysis Rules