Activity overview
Latest activity by robw
Feature Suggestion: Keyboard Shortcut to begin/end of block
Hi guys,
I've got a long block of code between BEGIN/END statements and scrolling by it is a pain, particularly on a remote connection. If I could jump to the beginning or end of a block of code vi...
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...
Equals sign after variable names in a SET statement
Is there a way to make an = appear automatically after I type a variable name right after a SET statement? A more general question would be "Is there a way to modify or extend the intellisense capa...
Suggestion: An object picker
I'm new to the Red-Gate tools and forum, so I apologize if this post is redundant or in an inappropriate place.
I use the Eclipse IDE quite a bit, and it has a very handy feature: CTRL-SHIFT-T brin...