EX0026 : Error found during the query binding phase |
 |
The topic describes the EX0026 analysis rule.
MessageError found during the query binding phase
DescriptionThe rule tries to generate a query execution plan and reports any errors appearing during the query binding phase.
How to fixCheck and investigate the reported errors.
ScopeThe rule has a Batch scope and is applied only on the SQL script.
Parameters| Name | Description | Default Value |
|---|---|---|
| ExpandMode |
The parameter specifies if stored procedures,function and view create statements to be expanded during analysis. |
ExpandAll |
RemarksThe rule requires SQL Connection. If there is no connection provided, the rule will be skipped during analysis.
Effort To Fix5 minutes per issue.
CategoriesExplicit Rules, Bugs
Additional InformationThere is no additional info for this rule.
Example Test SQL|
SQL
1select dd,dd1 from sys.objectsq 2 3select d3,dd1 from sys.objects |
Analysis Results| Message | Line | Column | |
|---|---|---|---|
| 1 | EX0026 : Invalid column name ‘d3’. | 3 | 0 |
| 2 | EX0026 : Invalid column name ‘dd1’. | 3 | 0 |
See Also