Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Call Stored Proc Parameters

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Call Stored Proc Parameters

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • August 5, 2009 at 1:30 am #11616
      ggenereux
      Member

      It would be nice to have a context menu action to generate the SQL call statement on stored procs.

      So, in addition to the Create Stored Proc, Alter Stored Proc, Drop Stored Proc, add Call this stored proc, and have it generate the call statement with templated parameters.

      Thanks much.

    • August 5, 2009 at 4:49 am #29422
      Khushboo
      Member

      Hi Ggenereux,

      Thank You for your interest in SQLyog.

      We will discuss about this feature request and let you know the status.

      Regards,

      Khushboo

    • August 5, 2009 at 7:59 am #29423
      peterlaursen
      Participant

      When we released SQLyog 5.0 years back we discussed an 'execute' option in the context menu. However if the SP takes parameters how could we know what to pass as parameter? We will need to open another dialogue of some kind then. Please explain how you imagine this?

      Also some SP's may change data and in that case a SP should not be executed unless in the correct context. Making it too easy can be somewhat dangerous. We discussed something like 'execute in sandbox' but dropped the idea.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.