What are the challenges you face when working across database platforms? Take the survey
Options

columns not available in stored procedure

susersuser Posts: 2
edited January 22, 2008 7:31AM in SQL Prompt Previous Versions
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?

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi there,


    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
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.