643 results found

1. convert SQL to a vbb (or c#) string statement

   in toad you can get it to convert a SQL statement into a VB or C# statement. i.e. if you have
   select * from atable
   where a = 'FREE'

   this would be converted to
   SQL = "select * from atable"
   sql =sql & "where a = 'FREE'"

   this is then pasted into the clipboard

   it can also do the reverse, have a chunk of VB code with a SQL statement, past it into the window, highlight it and it will try and convert it back to straight SQL (do not worry about variables added into the the vbcode, even toad cannot perform miracles) I used to use this a LOT!

   in toad you can get it to convert a SQL statement into a VB or C# statement. i.e. if you have
   select * from atable
   where a = 'FREE'

   this would be converted to
   SQL = "select * from atable"
   sql =sql & "where a = 'FREE'"

   this is then pasted into the clipboard

   it can also do the reverse, have a chunk of VB code with a SQL statement, past it into the window, highlight it and it will try and convert it back to straight SQL (do not worry about variables added into the the vbcode, even toad… more

   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

   0 comments  ·  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

2. Template based formatting with different

   Template based formatting.
   Select your text and right click, format according to template... then select the appropriate template of your choice.

   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

   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

3. Auto-Correct TOP to include Parenthesis

   Add an Enable checkbox in the Style Sheet | Global | Parenthesis settings.

   When SQL Prompt encounters the 'old style' usage of TOP, without parenthesis, automatically enclose the apparent 'what' in parenthesis.

   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

4. SQL History

   Over the years my Tab/Sql History became huge, and it is working very slow. I am looking for a way to clean up.
   1. There is no way to select multiple lines to delete. Delete is available only for one row. For example, every ALTER PROCEDURE creates history. I don’t need it at all. I would like to find all of them and delete.
   2. There is no functionality to compress and reindex Sql History database.
   3. Ironically “Send Feedback” link on a bottom of screen leads to nowhere.

   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

   under review  ·  2 comments  ·  Tab history  ·  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

5. Switch between Alias formats AS/=

   A formatting feature to change syntax between these two forms

   SELECT field1 AS Alias1, field2 AS Alias2 FROM table1

   SELECT Alias1 = field1, Alias2 = field2 FROM table1

   Ideally useable without having to invoke the "Format SQL" command.
   Hopefully selectable as an enabled option within a Format SQL style set.

   I spend a non-trivial amount of time reformatting SQL code for leading/trailing comma placement and alias AS/= placement, this would be a HUGE help

   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

6. refactor SELECT into CTE

   The way I work when creating complicated scripts is creating all the SELECT statements and then convert them to CTEs of my final query.
   It would be nice if you could convert SELECT into CTE

   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  ·  Script object as alter  ·  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

7. Finding tabs with the same code

   Hi, the possibility to sort/show tabs with the same code. Then you can delete history if you have more than one tab with the same code. This will make history smaller and faster.

   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  ·  Tab history  ·  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

8. Visual Studio Preview Support

   Please add support for Visual Studio Preview versions. We frequently work in those and SQL Prompt Pro specifically is not available.

   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  ·  Platform Support  ·  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

9. Formatting option to columnize not only column names but data-types and nullability as well

   Some of us would like the option for formatting of table declarations to not only align [tabify] column names (indented one tab), but also columnize/tabify the data types and nullability so that table definitions are grid-like. Constraints per column are are far more variable and therefore require more of a free format or sometimes pushing them to subsequent lines, but at minimum, the ColumnName, DataType and Nullability should be optioned to columnize by default.

   When there are hundreds or thousands of tables in a db schema, I'm used to scanning table definitions, and having them organized grid-like saves my eyeballs time and frustration. I realize not everyone organizes table schema in this way, but I manually format every table definition this way where I am allowed.

   Some of us would like the option for formatting of table declarations to not only align [tabify] column names (indented one tab), but also columnize/tabify the data types and nullability so that table definitions are grid-like. Constraints per column are are far more variable and therefore require more of a free format or sometimes pushing them to subsequent lines, but at minimum, the ColumnName, DataType and Nullability should be optioned to columnize by default.

   When there are hundreds or thousands of tables in a db schema, I'm used to scanning table definitions, and having them organized grid-like saves my eyeballs… more

   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

10. Formatting Styles - More granular control?

    I realize my title is very vague.

    Basically, I would like more control options over how styles are applied. Maybe I'm just really weird in how I format my SQL, but it seems like no matter how hard I try, I can never get the styles the way I want them.

    I realize that it's impossible to make it perfect. But the basic idea is to get the formatter to do what you would normally do the majority of the time.

    For example....the majority of the time, I prefer the following...

    For JOIN clauses, all join criteria is in the same line:

    JOIN dbo.Table t ON t.Foo = x.Foo AND t.Bar = x.Bar
    

    But for WHERE clauses, I prefer them to be on separate lines:
    WHERE x.Foo = 1
    AND x.Bar = 2
    AND y.Baz = 123

    Unfortunately, the formatter only allows one or the other.

    Another example, is with lists:
    For GROUP BY, I like them all on the same line

    GROUP BY x.Foo, y.Bar, z.Baz
    

    But for SELECT, I like the columns on separate lines (unless it's a short list, then put them all on the same line.)

    Unfortunately, the formatter also does not allow this. So now all of my group by's look like this:

    GROUP BY x.Foo
        , y.Bar
        , z.Baz
    

    I have a few more examples, but they're more oddball things that I like to do that are probably not as common.

    I realize my title is very vague.

    Basically, I would like more control options over how styles are applied. Maybe I'm just really weird in how I format my SQL, but it seems like no matter how hard I try, I can never get the styles the way I want them.

    I realize that it's impossible to make it perfect. But the basic idea is to get the formatter to do what you would normally do the majority of the time.

    For example....the majority of the time, I prefer the following...

    For JOIN clauses, all join criteria is in the… more

    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

11. Create a table variable from a table

    Very often I need to create a temp table, table variable, or UDTT that is a duplicate or subset of an existing table. I'd like the @table definition to include primary key and unique constraints and any check constraints and default constraints that are in the actual table. No foreign key constraints obviously. SSMS object scripting botches this up by creating a bunch of alter statements instead of including constraints inside the CREATE statement.

    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  ·  Script object as alter  ·  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

12. code folding

    Enabled Intellisense conflicts with SQL Prompt and needs to be disabled. This also disables Code Folding feature (Outline Statements) of SSMS, which is very useful for large coding projects.
    It would be helpful if SQL Prompt were to offer the similar feature.

    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  ·  Intellisense  ·  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

13. align aliases

    Please, separate options to align aliases for columns and tables..... I love aligned column aliases, but table aliases advance too far right, unnecessarily.

    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

14. More Casing/Capitalization Options

    Regardless of the source table, we would like the option to force table, column, and alias names to lower case. (We integrate databases from multiple sources and our queries look like a mess when half of the columns are upper case and half are lower).

    Example:
    SELECT dp.PROJID AS cpprojid,
    pld.suffix AS projectsegment,
    IP.projectnumber AS innprojid
    FROM DEL.PROJ AS dp
    INNER JOIN DEL.viewprojectlvldetail AS pld
    ON pld.PROJID = dp.projid
    LEFT OUTER JOIN inn.PROJ AS IP
    ON dp.PROJID LIKE IP.cpproj_id + '%'

    I think this is hard to read. We'd prefer the keywords to standout as uppercase and standardize all out table/column/alias names as lower case so they're easier to read and all of our servers/databases are of a Collation that can support it.
    
    Preferred format:

    SELECT dp.projid AS cpprojid,
    pld.suffix AS projectsegment,
    ip.projectnumber AS innprojid
    FROM del.proj AS dp
    INNER JOIN del.viewprojectlvldetail AS pld
    ON pld.projid = dp.projid
    LEFT OUTER JOIN inn.proj AS ip
    ON dp.projid LIKE ip.cpproj_id + '%'

    Regardless of the source table, we would like the option to force table, column, and alias names to lower case. (We integrate databases from multiple sources and our queries look like a mess when half of the columns are upper case and half are lower).

    Example:
    SELECT dp.PROJID AS cpprojid,
    pld.suffix AS projectsegment,
    IP.projectnumber AS innprojid
    FROM DEL.PROJ AS dp
    INNER JOIN DEL.viewprojectlvldetail AS pld
    ON pld.PROJID = dp.projid
    LEFT OUTER JOIN inn.PROJ AS IP
    ON dp.PROJID LIKE IP.cpproj_id + '%'

    I think this is hard… more

    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

15. Have the update process default to only updating installed tools

    I don't use SQL Prompt in Visual Studio and likely never will. However, every time I update, the updater defaults to installing it for VS and updating SSMS. It would be nice if the update process defaulted to only doing updates.

    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  ·  User interface  ·  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

16. Discover metadata for OPENQUERY

    When I use the OPENQUERY syntax to retrieve data across servers, SQL Prompt does not discover the metadata (column names, data types, etc.) of the fields returned.

    My suggestion is that you add support within SQL Prompt to make metadata for fields retrieved by OPENQUERY available just like you do for linked servers.

    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  ·  Intellisense  ·  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

17. Format pasted-in list

    I need a way to format a group of text items into a SQL query that I'm going to use for an "IN ('item1','item2','item3')" clause within the WHERE clause. There's got to be a simpler way than manually keying in all the single quotes and commas, particularly when the comma triggers SQL Prompt to start trying to prompt each time, so I have to add an Esc keypress to get SQL Prompt out of the way.

    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  ·  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

18. Create snippet to apply on each line in the selected text.

    I really love the add (quotes and) commas feature in SQL Prompt. Unfortunately we cannot produce a snippet similar to those.

    If you select some text it would be nice to format each line to a certain format.
    Like for example

    E46337E5-ECBC-41D4-A63E-A994E16BD8F7
    669F0B8E-5E1C-47CE-A799-81B47C9BC045
    65D23D56-7EB8-44AE-9158-C3D8B5684357
    AAFE4057-10B9-4AE8-BE76-C22537D29790
    4426C0B6-6216-4BFE-BE54-C1D917B593A5
    7BC5ED9E-E8C3-4618-B625-786F4B931D97
    01A37706-63FA-46E5-99EE-293FF290B34D
    94CAB432-EA1C-4972-8CD6-3C8B9E1A096B
    2C801ADE-995A-4158-9D0A-7DA03911D093
    425BAAC6-6A0B-419C-B393-79B21A628538

    turn into

    ('E46337E5-ECBC-41D4-A63E-A994E16BD8F7'),
    ('669F0B8E-5E1C-47CE-A799-81B47C9BC045'),
    ('65D23D56-7EB8-44AE-9158-C3D8B5684357'),
    ('AAFE4057-10B9-4AE8-BE76-C22537D29790'),
    ('4426C0B6-6216-4BFE-BE54-C1D917B593A5'),
    ('7BC5ED9E-E8C3-4618-B625-786F4B931D97'),
    ('01A37706-63FA-46E5-99EE-293FF290B34D'),
    ('94CAB432-EA1C-4972-8CD6-3C8B9E1A096B'),
    ('2C801ADE-995A-4158-9D0A-7DA03911D093'),
    ('425BAAC6-6A0B-419C-B393-79B21A628538')

    OR even better

    prepend

    SELECT t.x FROM (VALUES

    and append

    ) t(x)

    I often use this format to look up data in the database. I know I can achieve this with Excel and consorts. Or even with the help of block selection (that unfortunately doesn't function like it does in Visual Studio)

    The thing is you guys rock and you achieved it for the quotes and commas. So...

    I would be grateful.

    David

    I really love the add (quotes and) commas feature in SQL Prompt. Unfortunately we cannot produce a snippet similar to those.

    If you select some text it would be nice to format each line to a certain format.
    Like for example

    E46337E5-ECBC-41D4-A63E-A994E16BD8F7
    669F0B8E-5E1C-47CE-A799-81B47C9BC045
    65D23D56-7EB8-44AE-9158-C3D8B5684357
    AAFE4057-10B9-4AE8-BE76-C22537D29790
    4426C0B6-6216-4BFE-BE54-C1D917B593A5
    7BC5ED9E-E8C3-4618-B625-786F4B931D97
    01A37706-63FA-46E5-99EE-293FF290B34D
    94CAB432-EA1C-4972-8CD6-3C8B9E1A096B
    2C801ADE-995A-4158-9D0A-7DA03911D093
    425BAAC6-6A0B-419C-B393-79B21A628538

    turn into

    ('E46337E5-ECBC-41D4-A63E-A994E16BD8F7'),
    ('669F0B8E-5E1C-47CE-A799-81B47C9BC045'),
    ('65D23D56-7EB8-44AE-9158-C3D8B5684357'),
    ('AAFE4057-10B9-4AE8-BE76-C22537D29790'),
    ('4426C0B6-6216-4BFE-BE54-C1D917B593A5'),
    ('7BC5ED9E-E8C3-4618-B625-786F4B931D97'),
    ('01A37706-63FA-46E5-99EE-293FF290B34D'),
    ('94CAB432-EA1C-4972-8CD6-3C8B9E1A096B'),
    ('2C801ADE-995A-4158-9D0A-7DA03911D093'),
    ('425BAAC6-6A0B-419C-B393-79B21A628538')

    OR even better

    prepend

    SELECT t.x FROM (VALUES

    and append

    ) t(x)

    I often use this format to look up data in the database. I know I can achieve this with Excel and consorts. Or even with… more

    6 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  ·  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

19. SQL history - Allow user to set custom SqlHistory.db save location

    SQL Prompt allows users to set custom directories for various files.

    It would be nice to be able to change the location of the SqlHistory.db and other files that load to localappdata.

    I would love to have this update to a folder in my oneDrive folder so it is backed up and easier to migrate between computers.

    The only way to do this now is via REGEDIT.

    6 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  ·  User interface  ·  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

20. Allow LEFT, RIGHT, INNER and OUTER JOINS to be right-aligned to SELECT.

    Currently, FROM, WHERE, JOIN, and ODER can all be right-aligned to SELECT when formatting SQL. However, if you introduce a LEFT JOIN, the LEFT keyword is right-aligned to SELECT, and everything else is pushed over to make room for the JOIN. This is hideous and makes no sense.

    Instead, allow the entirety of "LEFT JOIN", "RIGHT JOIN", "INNER JOIN" and "OUTER JOIN" to right-align to the SELECT keyword.

    The attached images explain it better than I can.

    •  

    •  

    6 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