Competition: What’s your favorite Redgate tool? Enter now.

SQL Refactor qualifying columns with function name

andy3180andy3180 Posts: 9
edited May 15, 2007 12:30PM in SQL Refactor Previous Versions
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Thanks, I have reported this to the development team for fix action. Refactor has been trained to not qualify ALTER queries on functions, but it looks like it doesn't ignore them on SELECT queries.
Sign In or Register to comment.