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.
![](https://secure.gravatar.com/avatar/0a4de79bfdeeb7929063591438851056?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
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