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 https://forum.red-gate.com/categories/sql-prompt

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. Encapsulate As New stored procedure window re-sizable

    Make Encapsulate As New stored procedure window modeless, re-sizable, and zoom-able

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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 →
    • 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
        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
          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
            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)

            7 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              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