Suggestion: An object picker

• 
  Hi Rob,
  
  Many thanks for your post.
  
  Unless I am missing something here in what you are looking for, that is one of the things that SQL Prompt does.
  
  Whilst typing out T-SQL, SQL Prompt will automatically provide you with suggested candidates based on what you type. For example, using Adventureworks if you type "EXEC dbo.us" you will automatically be provided with a list of the stored procedures in the database that will narrow down the more characters you type, or you select a candidate from the list.
  
  If you do not wish for SQL Prompt to be on all the time, you can manually trigger suggestions by hitting CTRL + Space.
  
  Is this the sort of thing you are looking for Rob?

  peter.peart August 31, 2009 11:21

  - 0 +
• 
  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

  robw August 31, 2009 13:46

  - 0 +
• 
  Hi Rob,
  
  That would be fantastic. If you would like to send it to support(at)redgate.com and mark it for my attention, I will have a look and then raise a feature request for you.
  
  Pete

  peter.peart August 31, 2009 13:59

  - 0 +
• 

  robw wrote:

  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.

  
  Rob, have you tried out how SQL Prompt works?
  
  * Open a "New Query" window in SSMS
  * Type "AP" and hit TAB (should auto-complete to "ALTER PROCEDURE")
  * Start typing your procedure name, select from the list and hit TAB
  * SQL Prompt will pull the whole SP in ready for you to modify it.
  
  I think that is essentially what you are trying to do. (The above assumes you have TAB setup as a completion key.)
  
  The same works for Views and Functions, other than they don't have a pre-defined AV snippet for "Alter View" for some reason.

  MikeyC August 31, 2009 19:09

  - 0 +
• 
  WOW
  
  You learn something new every day , the other way to do it is if you are in an sp that calls another sp or fnc , just highlight the Sp name and the dialog opens , copy to clipboard and paste into a new query .
  
  But beware if the source sp have changed you may get an older version unless you have refeshed the schema

  MikeONeill September 01, 2009 03:52

  - 0 +
• 
  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

  robw September 01, 2009 17:29

  - 0 +

Add comment

Please sign in to leave a comment.