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?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(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 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)

    10 votes
    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)
      You have left! (?) (thinking…)
      0 comments  ·  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
      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)
        You have left! (?) (thinking…)
        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
        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)
          You have left! (?) (thinking…)
          0 comments  ·  Encapsulate as new stored procedure  ·  Flag idea as inappropriate…  ·  Admin →
        • Don't see your idea?

        Feedback and Knowledge Base