Options
columns not available in stored procedure
suser
Posts: 2
I have opened two files in SSMS. One is script.sql and has only queries
Second is proc.sql which has a stored procedure.
When I write a query in the script.sql, I get the dropdown list of columns for the table
When I write the same query in stored procedure, I do not get the dropdown list of columns after select.
What can I do to see the column list in a stored procedure?
Second is proc.sql which has a stored procedure.
When I write a query in the script.sql, I get the dropdown list of columns for the table
When I write the same query in stored procedure, I do not get the dropdown list of columns after select.
What can I do to see the column list in a stored procedure?
Comments
Please try this. In your editor click on SQL Prompt > Options (on the main menu bar). Now go to Listed Candidates > Performance and increase the value of "Search a fixed number of lines from the caret" from 50 up to say 200 or 300. If you don't notice any performance hit you might even want to increase this further. If this doesn't fix your problem please let us know.
Thanks,
Bart
Principal Consultant
bartread.com Ltd