Improve "read ahead" for variables
I find that in longer stored procedures, declared variables often don't show up as I start to type them. E.g. typing @ towards the beginning of the sp shows me a list of the variables, however if I'm further down in the proc, they ofter are not listed.
15
votes
![](https://secure.gravatar.com/avatar/4e09c9668e9f362d2e1adfae6562d306?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Anu commented
Thanks for your feature request. Variable scope is configurable. Please check this forum post for more details:
http://www.red-gate.com/MessageBoard/viewtopic.php?t=16615&highlight=parserlookbackdistanceLet me know if this solved the issue you are having.