EX0004 : Find identifier references inside the T-SQL script
Introduction
Section titled “Introduction”The rule scans T-SQL code for references to a specific identifier, as defined by the rule parameters. The rule can be used as a base rule for creating variants that identify references to particular identifiers in code.
Description
Section titled “Description”For example, the following query references the Sales table, which matches the IdentifierName rule parameter:
SELECT * FROM Sales WHERE SalesDate = @StartDate;This query will trigger a rule violation.
How to fix
Section titled “How to fix”The rule has a Batch scope and is applied only on the SQL script.
Parameters
Section titled “Parameters”| Name | Description | Default Value |
|---|---|---|
| IdentifierName | Identifier name. The parameter is required. | |
| CaseSensitive | Specifies if the identifier name is case sensitive. | no |
Remarks
Section titled “Remarks”The rule does not need Analysis Context or SQL Connection.
Effort To Fix
Section titled “Effort To Fix”Not configured.
Categories
Section titled “Categories”Explicit Rules
Additional Information
Section titled “Additional Information”There is no additional info for this rule.
Example Test SQL
Section titled “Example Test SQL”Analysis Results
Section titled “Analysis Results”No violations found.