Post reply

SQL Prompt Tips #1 - Selecting in the Object Explorer

  • May 7, 2014 at 1:28 pm

    #286476

    Comments posted to this topic are about the item SQL Prompt Tips #1 - Selecting in the Object Explorer

  • May 9, 2014 at 5:28 am

    #1712115

    Good Morning.

    How may I configure this shortcut?

    Thanks.

  • May 9, 2014 at 9:13 am

    #1712227

    There is no configuration. This is already set if you use SQL Prompt. If you don't have SQL Prompt, then I don't know how this would work.

  • May 23, 2014 at 7:00 am

    #1716036

    Hi Steve

    This sounds like a really useful tip, but what should I look for if it doesn't work?

    Ctrl/F12 does absolutely nothing, yes I do have SQL Prompt installed and it works fine when prompting.

    (SSMS 11.0.3000.0)

    Thanks

    Adrian

  • May 23, 2014 at 12:40 pm

    #1716222

    That's a tough question. I'd contact support. It's possible you have a key overload of some sort, based on your environment. Do you have Prompt 6? I think 6.3 is the latest incremental build.

    You can post a note here: http://www.red-gate.com/messageboard/viewforum.php?f=169 or click the contact support item.

  • May 23, 2014 at 12:40 pm

    #1716223

    found this as well: http://www.red-gate.com/messageboard/viewtopic.php?t=19630&highlight=ctrl+f12

  • October 14, 2015 at 2:56 am

    #1833152

    Only works for me if I highlight the object name and that name is not in brackets.

  • October 14, 2015 at 3:13 am

    #1833155

    it's working fine now, dunno what happened the previous time 🙂

    Thanks for the help

  • October 14, 2015 at 7:43 am

    #1833232

    I am a huge fan of Sql Prompt. Prior it seemed i would manage to memorize most of the database for quick querying.

    Do you know of a method to copy to pasteboard the quick text from sql prompt?

    EX: typing an exec stored procedure or select from a table a pause allows sql prompt to show the DDL.

    A short cut key to copy that code w/o taking hands off of the keyboard and using the mouse to click to copy button would be fantastic.

    thanks

    daryl

  • October 14, 2015 at 9:15 am

    #1833274

    This function will silently fail (no error msg) if the object you are searching for is new and does not yet appear in the object tree. Refreshing the tree may be necessary after creating an object. That would explain why it appeared to fail, but then later worked.

  • October 14, 2015 at 12:09 pm

    #1833309

    CTRL+Shift+D will refresh.

  • October 14, 2015 at 12:10 pm

    #1833310

    Daryl AZ (10/14/2015)

    I am a huge fan of Sql Prompt. Prior it seemed i would manage to memorize most of the database for quick querying.

    Do you know of a method to copy to pasteboard the quick text from sql prompt?

    EX: typing an exec stored procedure or select from a table a pause allows sql prompt to show the DDL.

    A short cut key to copy that code w/o taking hands off of the keyboard and using the mouse to click to copy button would be fantastic.

    thanks

    daryl

    Which text? Can you show an example? I'm not sure what you mean.

    BTW, you can submit suggestions on UserVoice, which the Prompt team is using for driving work.

    https://redgate.uservoice.com/forums/94413-sql-prompt

  • October 15, 2015 at 4:54 am

    #1833431

    Oooooo Good tip.

  • October 15, 2015 at 7:20 am

    #1833481

    Ex.

    Typing 'Select * from MyTable..' in SSMS SqlPrompt then brings up a list of tables fitting that spelling.

    Using arrow key down to go to specific table.

    At that point SqlPrompt then to the right of the table suggestions pops up a window with the DDL language for the suggested table. (or stored procedure)

    Using the mouse to click 'copy' I then have the code for the table/sproc for debugging, investigating.

    thanks

    daryl

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply