Prefixes in function parameters
SQL Prompt is removing prefixes from column names used as parameters in function-calls. For example, if you use Cross Apply to a system function:
SELECT *
FROM sys.tables AS T
CROSS APPLY sys.fnlistextendedproperty('blah','schema',schemaname(T.schemaid), 'table', T.name, null, null)
It removes "T." from schemaid and name in the parameters list. This means I have to add them back in if the column names are ambiguous. I don't see a setting for this, and have Prompt set to add prefixes to columns in the other clauses. So it'll add "T." to a column in the Select clause, and remove it from the same column in the function parameters.
GSquared
shared this idea
-
Adrian Tompkins
commented
I am seeing the same issue. It should respect the qualification settings.
-
GSquared
commented
Clarification: I'm asking to have this fixed so it leaves them in there, like it does in the rest of the query.