Executing stored procedure parameter strings without quotes?

• shannonjk

  SSCarpal Tunnel

  Points: 4286

  More actions

  May 26, 2011 at 4:32 pm

  #240365

  Greetings all,

  So the default shortcut keys to use, Alt+F1 for sp_help for instance (I am running SQL Server 2008 enterprise sp2) is fine and dandy in most situations to highlight a table or various database object and execute to get some helpful information about said object. However, I have a database that uses a few schemas which are not the default dbo schema. As most of us are aware, you must schema qualify anything that is not the default schema (usually dbo). From what I gather, highlighting a database object and hitting Alt+f1 only works on non-schema qualified objects in the default schema. It does work however by putting the schema qualified object in quote strings. For instance selecting 'schema.table' and hitting Alt+f1 works (assuming you have a schema.table object in your db) however, this effectively removes the convenience of having a hotkey you can execute on the fly.

  I have tried making my own stored procs that pass the input into string quotations but it does not work. So my question is; is there anyway around this type of situation without having to put things in quotations?

  Link to my blog http://notyelf.com/

• Latheesh NK

  SSCertifiable

  Points: 6559

  More actions

  May 27, 2011 at 12:40 am

  #1330794

  Refer the below link for the same and vote for it....

  Also there is a solution, try with if it suits your req...

  http://sqlblogcasts.com/blogs/simons/archive/2009/03/25/Getting-sp_5F00_help-to-work-with-schemas-from-keyboard-shortcuts.aspx