EX0026 : Error found during the query binding phase

The topic describes the EX0026 analysis rule.

Message

Error found during the query binding phase

Description

The rule tries to generate a query execution plan and reports any errors appearing during the query binding phase.

How to fix

Check and investigate the reported errors.

Scope

The 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

Remarks

The rule requires SQL Connection. If there is no connection provided, the rule will be skipped during analysis.

Effort To Fix
Not configured.
Categories

Explicit Rules, Bugs

Additional Information

There 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

Other Resources