80 results found

1. Improve tab & parenthesis placement of subqueries ...wherever placed in query

   Would like improve tab & parenthesis placement of subqueries ...wherever placed in query ...be it in JOIN, WHERE, HAVING ...or even in SELECT ...ALSO would like option for 1st tabbed item in SELECT list to be the starting position on each row for each subsequent item which includess the placement of the 'prefixed' comma ...see below...

   BEFORE (Current formatting)...

   LEFT OUTER JOIN (
   SELECT
   f1
   , f2
   , f3
   FROM
   dbo.t1
   WHERE
   f9 = 'x'
   ) AS e
   ON e.f1 = b.f1
   AND e.f2 = b.f2

   AFTER...

   LEFT OUTER JOIN
   (
   SELECT
   f1
   , f2
   , f3
   FROM
   dbo.t1
   WHERE
   f9 = 'x'
   )
   AS e
   ON e.f1 = b.f1
   AND e.f2 = b.f2

   Would like improve tab & parenthesis placement of subqueries ...wherever placed in query ...be it in JOIN, WHERE, HAVING ...or even in SELECT ...ALSO would like option for 1st tabbed item in SELECT list to be the starting position on each row for each subsequent item which includess the placement of the 'prefixed' comma ...see below...

   BEFORE (Current formatting)...

   LEFT OUTER JOIN (
   SELECT
   f1
   , f2
   , f3
   FROM
   dbo.t1
   WHERE
   f9 = 'x'
   ) AS e
   ON e.f1 = b.f1
   AND e.f2 = b.f2

   AFTER...

   LEFT OUTER JOIN
   (
   SELECT
   f1
   , f2
   , f3
   FROM
   dbo.t1
   WHERE… more

   17 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   4 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Andrei Rusitoru responded

   This feature was released in version 8.1 of SQL Prompt as part of our rework of parentheses formatting.

   If there are any missing features please let us know by creating a new suggestion.

   Kind Regards,
   The Prompt Team

2. semicolon: space before/after options

   Request space options for semicolons that are analogous to space options for commas (see SQL Prompt-->Options-->Format-->Commas & parentheses)
   p.s. -I really don't like the current auto-insertion of a space in front of the semicolons. At the very least, the semicolon formatting should remain untouched upon running Format SQL.

   17 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

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

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Paul Stephenson responded

   As of SQL Prompt 5.2.8, spaces are no longer inserted before semicolons during a Format SQL operation. We have not added a new option, as we have found no-one who likes the spaces to be there. If we receive further feedback to the contrary then we will consider adding an option in the future.

3. Moving commas from "end" to "start" is always buggy when comments exist

   Moving commas from "end" to "start" or vice-versa is buggy when comments exist after each column or parameter. This is an issue regardless of the type of statement (SELECT, INSERT, UPDATE, CREATE TABLE/VIEW/FUNCTION/STORED PROCEDURE, etc).

   Here is my original SP with commas at "end" followed by comments (hyphens are used for indentation due to HTML formating issues):
   CREATE PROCEDURE dbo.MyProcedure
   ---- @Param1 int, --Param1 comments
   ---- @Param2 int, --Param2 comments
   ---- @Param3 int --Param3 comments
   AS
   BEGIN
   ---- SELECT Col1 , --Col1 comments
   ---- ---- Col2 , --Col2 comments
   ---- ---- Col3 --Col3 comments
   ---- FROM MyTable
   ---- RETURN
   END
   GO

   After CTRL+K+Y, the commas and comments are incorrectly placed on their own separate line:
   CREATE PROCEDURE dbo.MyProcedure
   ---- @Param1 int
   ---- , --Param1 comments
   ---- @Param2 int
   ---- , --Param2 comments
   ---- @Param3 int --Param3 comments
   AS
   ---- BEGIN
   ---- ---- SELECT Col1
   ---- ---- ---- , --Col1 comments
   ---- ---- ---- Col2
   ---- ---- ---- , --Col2 comments
   ---- ---- ---- Col3 --Col3 comments
   ---- ---- FROM MyTable
   ---- ---- RETURN
   ---- END
   GO

   Alternatively when moving commas from "start" to "end" the commas are placed on their own line, but at least comments follow the statement. Going from either direction, this formatting is both ugly and unproductive. Moving comments to a new line is confusing! Either way this buggy issue robs us of valuable vertical screen space.

   We regularly receive code that needs to be re-formatted to our own preferences. Please modify SQL Prompt to always leave both commas AND comments on the same line but still move commas to our preferred location ("start" or "end").

   Thank you.

   Moving commas from "end" to "start" or vice-versa is buggy when comments exist after each column or parameter. This is an issue regardless of the type of statement (SELECT, INSERT, UPDATE, CREATE TABLE/VIEW/FUNCTION/STORED PROCEDURE, etc).

   Here is my original SP with commas at "end" followed by comments (hyphens are used for indentation due to HTML formating issues):
   CREATE PROCEDURE dbo.MyProcedure
   ---- @Param1 int, --Param1 comments
   ---- @Param2 int, --Param2 comments
   ---- @Param3 int --Param3 comments
   AS
   BEGIN
   ---- SELECT Col1 , --Col1 comments
   ---- ---- Col2 , --Col2 comments
   ---- ---- Col3 --Col3 comments
   ---- FROM MyTable
   ---- RETURN
   END… more

   16 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

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

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Andrei Rusitoru responded

   This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

   You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/

   Thank you for your help!

4. SQL Prompt > Format SQL Update for SQL Server 2016

   Any query where "AT TIME ZONE" is used (new feature in SS '16), the Format SQL throws and error.

   "SQL Prompt was unable to complete this operation. Problem areas have been highlighted"

   The highlighting start from "AT TIME ZONE..."

   Thank you

   14 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

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

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Michael Clark responded

   We now support “AT TIME ZONE” in the latest release of SQL Prompt. You can download the latest release here:
   https://forum.red-gate.com/discussion/80988/latest-stable-build-of-sql-prompt-is-8-0-0-1241-11th-may#latest

   Thanks for your support!

5. Add brackets to all database objects

   Similar to the existing Qualify Object Names and the other pending request to fix case of all object names, I would like to have an option to add brackets added to all database object names (columns, tables, schemas) where they are missing.

   13 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   4 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   This is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

6. Option to place Table names on the same line as the keyword

   Currently, no matter what settings are applied, table names are always placed on a new line, for example:

   SELECT
   ID,
   Thing

   FROM
   TableName

   JOIN
   OtherTableName
   ON blah=moo

   WHERE
   something <> something else

   My personal preference is for:

   SELECT
   ID,
   Thing

   FROM TableName

   JOIN OtherTableName
   ON blah=moo

   WHERE something <> something else

   Please can we have an option to achieve table names on the same line as their action (FROM / JOIN)

   13 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   11 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Andrei Rusitoru responded

   This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

   You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/

   Thank you for your help!

7. Line up type declarations

   I would like an option to align the type declarations, for example when declaring the columns in a table variable I currently get:
   DECLARE @MyExample TABLE
   (
   MyCol1 INT ,
   MyOtherCol VARCHAR(10)
   )

   Which I would quite like to see laid out as:
   DECLARE @MyExample TABLE
   (
   MyCol1 INT ,
   MyOtherCol VARCHAR(10)
   )

   The same is true for all other places where I'm declaring, so the parameters for a procedure for example

   12 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   4 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Andrei Rusitoru responded

   This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

   You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/

   Thank you for your help!

8. Auto generated INSERT statement is buggy with commas at start

   The auto-generated INSERT statement BADLY MISALIGNS data when "Place commas at start" is enabled. I've listed all the settings to reproduce the issue at the end of this post.

   The comma and associated info are on a separate line (almost useless - Worse when I need to delete some of the columns). See this example (generated by SQL Prompt Pro 5.1 - hyphens represent tabs due to HTML limitations):

   INSERT INTO dbo.Test
   ---- (FirstName
   ---- , LastName
   ---- , LocationAddress
   ---- , LocationCity
   ---- , LocationState
   ---- , LocationZip)
   VALUES (''
   ---- , -- FirstName - varchar(100)
   ---- ''
   ---- , -- LastName - varchar(100)
   ---- ''
   ---- , -- LocationAddress - varchar(100)
   ---- ''
   ---- , -- LocationCity - varchar(100)
   ---- ''
   ---- , -- LocationState - varchar(50)
   ---- '' -- LocationZip - varchar(10)
   ---- )

   When "Place commas at end" is enabled it works correctly. Please fix the "place commas at start" option to work like this, but with preceeding commas of course:

   INSERT INTO dbo.Test
   ---- (FirstName,
   ---- LastName,
   ---- LocationAddress,
   ---- LocationCity,
   ---- LocationState,
   ---- LocationZip)
   VALUES ('', -- FirstName - varchar(100)
   ---- '', -- LastName - varchar(100)
   ---- '', -- LocationAddress - varchar(100)
   ---- '', -- LocationCity - varchar(100)
   ---- '', -- LocationState - varchar(50)
   ---- '' -- LocationZip - varchar(10)
   ---- )

   You can reproduce this issue with the following settings from the SQL Prompt menus:

   Format > Commas and Parentheses:
   ----"Place commas at start"

   Inserted Code > Objects & Statements:
   ----"Insert full INSERT statement"
   --------"Show column names" and/or "Show column data types"
   --------"Insert default value for each column"

   The auto-generated INSERT statement BADLY MISALIGNS data when "Place commas at start" is enabled. I've listed all the settings to reproduce the issue at the end of this post.

   The comma and associated info are on a separate line (almost useless - Worse when I need to delete some of the columns). See this example (generated by SQL Prompt Pro 5.1 - hyphens represent tabs due to HTML limitations):

   INSERT INTO dbo.Test
   ---- (FirstName
   ---- , LastName
   ---- , LocationAddress
   ---- , LocationCity
   ---- , LocationState
   ---- , LocationZip)
   VALUES (''
   ---- , -- FirstName - varchar(100)
   ---- ''
   ----… more

   11 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   5 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

9. Remove extra space between statements option is Needed

   SELECT
   *
   FROM
   Temp1

   --Remove this kind of extra spacing between statements option is Needed
   

   SELECT
   *
   FROM
   Temp2

   --Remove this kind of extra spacing between statements option is Needed
   

   SELECT
   *
   FROM
   Temp3

   10 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   4 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Andrei Rusitoru responded

   This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

   You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/

   Thank you for your help!

10. Format SQL - quick styles

    I want to switch between TEAM and PERSONAL styles for Format SQL. It currently takes 8 mouse clicks to achieve this. Could you add a style lookup on the context menu or Red Gate tools menu and apply the style to the current document automatically as soon as it is selected.

    I want my team to be able to work in their personal SQL format, but always save in the TEAM format.

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Andrei Rusitoru responded

    This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

    You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/

    Thank you for your help!

11. semi colon placed on new line

    Place semi-colon on new line.

    I frequently format my statements as I'm developing them, but multiple times now I've started to add an Order By or some other clause after the auto-inserted semi-colon. I would like to see an option to place the semicolon on the line following the sql statement rather than directly after. This would enable me to start typing at the start of the next line without having to check if a semicolon had been added to the preceding line.

    Example:
    Select * From Table
    Where A = 1; -- Semicolon added by formatting
    Order By A

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Andrei Rusitoru responded

    This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

    You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/

    Thank you for your help!

12. Give Format SQL the ability to convert X.Field1 AS NewFieldName format to FieldName = X.Field1

    We have a lot of legacy code that is written as

    SELECT Field1 as Name1, Field2 Name2 FROM Table X
    (Sometimes they use AS when setting the alias, othertimes they do not).

    I would love the ability to convert this to
    SELECT
    Name1 = X.Field1
    , Name2 = X.Field2
    FROM Table X

    Both having the ability to switch between Name = Value and Value AS Name and to auto add the alias to all fields.

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    6 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 7.3 of SQL Prompt.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

13. Option to align AND predicates with WHERE

    Would love to be able to have all predicates at the same indent level ie:

    WHERE something = yetsomethingelse
    AND somethingelse = anotherthing

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Thomas Walsh responded

    We’ve released support for formatting options such as this in version 8.0 of SQL Prompt.

    You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.

    If there is something missing please let us know by opening a new suggestion.

    Kind regards,

    The Prompt Team

14. Do not indent FROM and WHERE clauses

    Provide an option to not indent the FROM and WHERE clauses to remain them lined up with the SELECT clause while maintaining a single space after each clause.

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Andrei Rusitoru responded

    This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

    You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/

    Thank you for your help!

15. 2012 keywords

    2012 keywords like LEAD( LAG( etc.

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    We’ve released SQL Prompt 6 which includes support for 2012 analytic functions (LEAD, LAG, CUME_DIST, etc)

16. Ability to quickly switch SQL formatting styles.

    We need the ability to quickly switch between T-SQL Formatting styles.

    I work on a team where everyone likes code formatted differently. Also, we're required to use a specific format before checking SQL Code into TFS. I need a quick way to switch between styles so I can code in a format I like and then switch to our standard before check-in. Toad already offers this.

    8 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Thomas Walsh responded

    Version 8.0 of SQL Prompt allows you to quickly switch between formatting styles by clicking SQL Prompt → Active Style → (the style you’d like).

    You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.

    If there is something missing please let us know by opening a new suggestion.

    Kind regards,

    The Prompt Team

17. Merge command formatting options

    Please add formatting options for the deferent parts of the MERGE command like you have for INSERT

    8 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Andrei Rusitoru responded

    This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

    You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/

    Thank you for your help!

18. Surround list of values with quotation marks and separate by commas

    when creating a WHERE colname IN ('a','b','c')

    it would be nice if you could paste a set of rows from excel into SSMS and then add the quotation marks and commas

    i.e.

    A
    B
    C

    becomes

    'A',
    'B',
    'C'

    7 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    SQL Prompt 7 now has an “Add quotes and commas” feature which can be accessed by selecting the block of text and tapping ctrl to bring up the Actions List. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/

19. Remove trailing spaces

    Option to remove trailing spaces from script lines. This can be done via search/replace functionality but it would be nice to have this taken care of automatically during the SQL code reformatting

    7 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Thomas Walsh responded

    Version 8 of SQL Prompt allows you to do this as part of its new formatting system.

    You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.

    If there is something missing please let us know by opening a new suggestion.

    Kind regards,

    The Prompt Team

20. Its a very nice tool who made developer life very easy and do a major and boring task of code formatting by just pressing CTRL+K+Y.

    Its a very nice tool who made developer life very easy and do a major and boring task of code formatting by just pressing CTRL+K+Y.
    i need a feature who can help developer very much like 1)If there is a SQL Insert query and i select a field it should highlight the value assigned to that selected field because finding this become more painful in formatted code.

    7 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    SQL Prompt now contains the Highlight Matching Objects feature: https://documentation.red-gate.com/display/SP7/SQL+Prompt+7.1+release+notes#SQLPrompt7.1releasenotes-Highlightmatchingobjects