Comments
Sort by recent activity
That's exactly what I was looking for. Eclipse uses a prompt window, but the end result is the same thing: The stored procedure you want is in an edit window.
Thanks!
Rob / comments
That's exactly what I was looking for. Eclipse uses a prompt window, but the end result is the same thing: The stored procedure you want is in an edit window.
Thanks!
Rob
Peter,
Thanks for your reply. You are correct in the context of editing SQL. SQL Prompt does this for you when you want to exec another stored procedure, or reference a table, or use a reserved word.
I'm talking about realizing that you need to open an existing stored procedure for editing. In the Eclipse example, when you hit CTRL-SHIFT-T, a new box opens up. You type a few characters, and matching classes come up. You pick the class, and it opens for editing.
The reason I ask for this feature is because of client sites that have hundreds of stored procedures. Scrolling down the object browser is time consuming and not very user friendly. Opening up a window to type a few charaters, picking the correct stored procedure, then having it open up as "ALTER PROCEDURE ..." would be a nice feature.
If you like, I could create a small movie demonstrating the feature in action and send it to you.
Rob / comments
Peter,
Thanks for your reply. You are correct in the context of editing SQL. SQL Prompt does this for you when you want to exec another stored procedure, or reference a table, or use a reserved wor...