Options
SQL Refactor qualifying columns with function name
andy3180
Posts: 9
In a case where the code selects columns from a function, SQL Refactor is prefixing the function names to the columns which is results in an error while trying to execute that code in Query Analyzer
e.g. SELECT Col1, Col2 FROM funcXYZ(10, 20)
is changed to
SELECT funcXYZ.Col1, funcXYZ.Col2 FROM funcXYZ(10, 20)
This results in the following error -
The multi-part identifier "funcXYZ.Col1" could not be bound
e.g. SELECT Col1, Col2 FROM funcXYZ(10, 20)
is changed to
SELECT funcXYZ.Col1, funcXYZ.Col2 FROM funcXYZ(10, 20)
This results in the following error -
The multi-part identifier "funcXYZ.Col1" could not be bound
Comments