How can we help you today? How can we help you today?

SQLPrompt doesn't recognize "rollup" as reserved word

I have set SQL Prompt to automatically remove those [silly] and [[[useless]] [brackets]]]] where possible. Great with inherited code...

However, I just ran into a situation where this causes an error. A predecessor had decided that "rollup" would be a great column name. SSMS marks this as reserved word, but SQL Prompt disregards that and strips off the brackets anyway. In most cases, that doesn't even cause an error.
....
Except when "rollup" is used in the GROUP BY clause, where SQL Server now expects it to be the ROLLUP() function and complains about missing parentheses.

Please fix to either always retain brackets around "rollup", or at least retain them when used in GROUP BY.
HugoKornelis
0

Add comment

Please sign in to leave a comment.