identify occurrences of select *
Now that sql prompt and refactoring have been merged, how about a means of identifying where 'select ' has been used in stored procedures etc. including select a. and select bob, *
I would have thought that you've already done the hard work, as SQL prompt already recognises these stars when it proposes to expand the column list.
2
votes
dmckinney
shared this idea
We’re happy to announce that this feature is now included in SQL Prompt V9 as part of the new code analysis feature. For additional information see: https://documentation.red-gate.com/display/SP9/SQL+Prompt+9.2+release+notes.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
Thank you for your help!
Kind regards,
The Prompt Team