SQL Prompt

Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.

If you have any questions, need help or have found a bug in SQL Prompt, please visit the forums at http://www.red-gate.com/messageboard/viewforum.php?f=169.

How can we improve SQL Prompt?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Be able to highlight a chunk of SQL and right click and create a new Stored Procedure or function out of it and then it

    Be able to highlight a chunk of SQL and right click and create a new Stored Procedure or function out of it and then it would replace the highlighted SQL with a exec statement to exec that new sp that was just created.

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      1 comment  ·  Encapsulate as new stored procedure  ·  Flag idea as inappropriate…  ·  Admin →
    • Encapsulate as new stored procedure

      I would like to have template(s) for "Encapsulate as new stored procedure". for example I use
      IF OBJECT_ID('dbo.SPName, 'P') IS NOT NULL
      DROP PROCEDURE dbo.SPName
      GO

      CREATE PROCEDURE dbo.SPName
      ...
      WITH ...

      2 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Encapsulate as new stored procedure  ·  Flag idea as inappropriate…  ·  Admin →
      • Encapsulate SQL to View + Suggested index for the resulting view

        give the option to encapsulate a piece of code like a subquery into a view so it can be reused , and give an option to create indexes on the resulting views as to max speed to the query

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Encapsulate as new stored procedure  ·  Flag idea as inappropriate…  ·  Admin →
        • Encapsulate the current statement in table valued function

          It could be useful to wrap the result of a select statement into a table valued function (inline or multistatement)

          6 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Encapsulate as new stored procedure  ·  Flag idea as inappropriate…  ·  Admin →
          • Don't see your idea?

          Feedback and Knowledge Base