Skip to content

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 or our support portal.

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

172 results found

  1. Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words.
    "Status", "description", and "Type" are examples of special words that are syntax highlighted, but they aren't full reserved keywords, so would want the brackets kept.

    How to configure and prevent SQL Prompt from removing brackets around Syntax highlighted words?
    We only have the following settings:
    a) Options > Inserted Code > Special Characters > Brackets > Enclose identifiers within square brackets [] = NO (which is our desire)
    b) Options > Format > Styles > Actions > run format > Add/remove square brackets = YES,…

    30 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. If format SQL makes chnages - it destroy saved marks
    This occurs even when line bookmarked line hasnt (visibly) changed
    Very frushtrating

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. What I’m proposing, would change the way we type our SQL scripts. I’m not suggesting we try to pass or force through a new SQL standard. I’m simply suggesting a new dynamic “view” of the SQL syntax, which would allow for a more natural support of intellisense. With today’s IDE’s this simply doesn’t work. Intellisense doesn’t know where to pull the “what” from. The “what” comes from the “where”, (the FROM clause).

    The underlying SQL script itself, would still comply with the SQL standards. This “view”, would perform three tasks: 1) allow the end-user to type their SQL more like…

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. I think it would be great if SQL Prompt had the functionality to expand a view that is used in a query. So if you have this schema:
    CREATE TABLE dbo.Person
    (
    PersonID INT IDENTITY(1, 1)
    PRIMARY KEY,
    LastName VARCHAR(30),
    FirstName VARCHAR(30),
    );
    GO

    CREATE TABLE dbo.Student
    (
    StudentID INT IDENTITY(1, 1)
    PRIMARY KEY,
    PersonID INT,
    StudentNo VARCHAR(100)
    );
    GO

    CREATE TABLE dbo.Class
    (
    ClassID INT IDENTITY(1, 1)
    PRIMARY KEY,
    ClassName VARCHAR(100)
    );
    GO

    CREATE TABLE dbo.ClassRoster
    (
    ClassID INT,
    StudentID INT
    );

    GO

    CREATE VIEW dbo.Students
    AS
    SELECT
    S.StudentID,
    P.LastName,
    P.FirstName,
    S.StudentNo
    FROM
    dbo.Person AS P
    JOIN dbo.Student AS…

    16 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. It would be awsome if there was an option that would format an SQL Script automatically after opening it in SSMS / VS. So if you load a file it would be formatted automatically with your selected formatting style. It would be great too if this auto format option could be switched on and off in the Options.

    17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Setting the option to use spaces instead of tabs for intending (our house policy) only works for new tab presses.
    I would like a simple action that would replace all tabs in the current document with spaces -- using the tab-to-spaces value as set in options. Sublime Text has this and I use practically every time I edit anything.

    57 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. 15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. Convert selected CODE or a complete stored procedure to Dynamic SQL Code.

    16 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Template based formatting.
    Select your text and right click, format according to template... then select the appropriate template of your choice.

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. Add the ability to exclude columns from appearing in the auto-generated INSERT statements. I have to manually remove certain columns every time.

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. I align aliases, commas, datatypes and expressions at the first tab stop following the longest element in the list. See examples below:

    -- Tilde character used as space replacement to cope with HTML formatting
    -- 2-character tabs are assumed below
    -- In a fixed-space font, the commas, = signs, data types and AS keywords would all line up vertically
    DECLARE
    ~~@x~~~~~~~~~~~~~~INT~~~~~~~~~,
    ~~@var~~~~~~~~~~~~VARCHAR(4)~~,
    ~~@longer_varname~VARCHAR(10)~,
    ~~@z~~~~~~~~~~~~~~DATETIME~~~~;

    SELECT
    ~~~~@longer_varname~=~'x'~~~~~~~,
    ~~~~@var~~~~~~~~~~~~=~'1234'~~~~,
    ~~~~@z~~~~~~~~~~~~~~=~GETDATE()~;

    SELECT
    ~~~~T1.shortfield~~~~~~~~AS~ShortField~,
    ~~~~AO.really
    longfield~~AS~LongField~~,
    ~~~~'x'~~~~~~~~~~~~~~~~~~~AS~XChar~~~~~~,
    ~~FROM~~~~~~~~dbo.table1~~~~~~AS~T1
    ~~~~LEFT~JOIN~dbo.another
    one~AS~AO~ON~T1.keyval~=~AO.keyval;

    EXEC~@x~=~dbo.SomeProc
    ~~@Param1~=~'3'~~~~~~~~~~~,
    ~~@P2~~~~~=~'Longer~Text'~,
    ~~@P3~~~~~=~4~~~~~~~~~~~~~;

    24 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. I would be nice if SQL-prompt could warn against posible data truncation.
    Like assigning a int value to a tinyint field/variable or assigning a varchar(30) to a varchar(3).
    I want it both at an global analysis (like find invalid objects) and in the current scrip edit (while modifying a trigger / procedure / function).

    13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
1 2 5 6 7 9 Next →
  • Don't see your idea?