shortcut key to procedure with multiple input parameters in sql server 2005

• ssisnovice

  SSC-Addicted

  Points: 481

  More actions

  February 10, 2012 at 2:04 am

  #391527

  Hi,

  I have a 2 stored procedures. One procedure accepts one input parameter and the second one accepts 2 input parameters. I assigned a shortcut keys to both procedures.

  shortcut key for procedure with one iput parameter works fine where as the procedure with 2 input parameters gives error at second parameter. It works fine when I execute with exec command.

  Can't we assign a shortcut key for a multiple parameterized procedure.

  Error: Msg 201, Level 16, State 4, Procedure SELECTQUERY, Line 0

  Procedure or Function 'SELECTQUERY' expects parameter '@PKG_NAME', which was not supplied.

  Appreciate any work around for this

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 10, 2012 at 3:52 am

  #1445436

  Assign a default to the second parameter in case it is not passed.

  There's not much you can do about it, other than that.

  -- Gianluca Sartori