663 results found

1. Ability to code analyse existing database (SPs, triggers, etc.)

   SQL Prompt provides the ability to improve your on-the-fly coding according to standards and best practices defined locally or within the organisation.

   How about the ability to analyse an existing database and isolate problematic areas, code smells and provide not only recommendations but also the ability to refactor the database code based on rule-sets?

   This would be really great and a time-saver to improve the code quality in the whole database.

   Thanks, Jochen Kirstätter, MVP

   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  ·  Code Analysis  ·  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. Auto generate parameters based on a scan of a query

   I tend to debug SSRS queries/scripts quite a lot in SSMS. Usually these queries contain 1-10 parameters. It would save large amounts of time if I can paste the query into SSMS and run some SQL Prompt command to auto generate at the top of the query all the parameter declarations ready for default values.

   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  ·  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. Indicate if an object is SELECT only or contains data insert/update/delete operations

   Often when reviewing someone else's objects I have to open them and scan through to determine if they are truly read only or if they contain data modification code (delete,update, insert, merge, etc...). It would be most helpful if SQL prompt could show a flag for read only vs data mod objects (when you hover over and click to open the summary window displaying it there would be ideal). It would be best if it could check dependencies (if the object called others)

   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

   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

4. Pin feature for quick info

   When the mouse pointer is hovered over a table or stored procedure etc, an intelli-sense like link is shown which can clicked to bring up the object definition, which disappears when something else is selected.

   My suggestion would be a pin feature, so that we can keep the object definition quick info box visible on the screen for reference instead of it disappearing.

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

5. Smart Rename to change case

   sometimes I need to just change the casing of letters in a field name (e.g. a field has GUID and I want to make it Guid). smart rename does not allow me to change the name if the new name is exactly the same saying that a column with this name already exists.

   so I change the name to GuidXXXX and then on the generated script remove the XXXX and the script runs just fine.

   I think smart rename should not warn that the name exists if I am just changing casing of the name

   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  ·  Smart rename  ·  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. Add Excel Like Gripd To Results Options

   Add to the Results To options an Excel Like grid that presents the results i8n a grid but allows for Excel like functuionality without re-executing the query.

   I often am sending my data (via copy & paste) to Excel for aditional reserahc because the query takes a long time to run and I alrady have the core data I needd, I just need to fin tune it bu re-sorting or even re-aggregating the data differently.

   It wulod be a killer plus if Microsoft simply reaplced the existing SSMS Grid with a mini-version of Excel but since Thats not likely any time soon how about provodong the Red=Gate Spreadhseet grid for SSMS?

   Add to the Results To options an Excel Like grid that presents the results i8n a grid but allows for Excel like functuionality without re-executing the query.

   I often am sending my data (via copy & paste) to Excel for aditional reserahc because the query takes a long time to run and I alrady have the core data I needd, I just need to fin tune it bu re-sorting or even re-aggregating the data differently.

   It wulod be a killer plus if Microsoft simply reaplced the existing SSMS Grid with a mini-version of Excel but since Thats not likely any… 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

   7 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

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

8. 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

9. 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

10. 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

11. 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

12. 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

13. 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

14. 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

15. 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

16. 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

17. 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

18. 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

19. 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

20. 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