669 results found

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

2. COPY AS ALTER BUTTON

   Hello,

   So I love the suggestion feature where I'm able to type in an object and the code appears to copy. Home run with this feature I can't thank you enough for it.

   I was wondering if it would be possible to expand on it though.

   Here is a sample. I'm looking to alter an object, let's say a stored proc...
   I usually begin by typing EXEC <name> to trigger the suggestion for stored procs to give me the object.

   Once the suggestion finds the object, the script contents appears in a side window.

   Using the COPY button in the right corner, I copy the next and paste to my current session window (overriding the previous EXEC <name> statement)
   However I still need to change the CREATE statement to an ALTER statement.

   Then I remember that I can use F12 to Script Object as ALTER. That's great, however it opens the object in a new window.

   Have you ever been buried with so many tabs opened that are either pinned/not pinned during business hours? It sometimes becomes a (slight) problem when you see numerous SQLQueryXX.sql tabs listed and you have to remember to go back and close the previous one that you used to trigger the suggestion.

   So my question - would it be possible to have an ability to have something like a COPY AS ALTER button, similar to the COPY button in the screenshot?

   The functionality is already there, you'd just be adding a nice convenient button that would really be appreciated!

   Thank you for your consideration.

   Hello,

   So I love the suggestion feature where I'm able to type in an object and the code appears to copy. Home run with this feature I can't thank you enough for it.

   I was wondering if it would be possible to expand on it though.

   Here is a sample. I'm looking to alter an object, let's say a stored proc...
   I usually begin by typing EXEC <name> to trigger the suggestion for stored procs to give me the object.

   Once the suggestion finds the object, the script contents appears in a side window.

   Using the COPY button in the… more

   1 vote

   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  ·  Edit…  ·  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. Autofix : SC002 – Script should end with empty line

   SQL prompt currently removes the empty line at the bottom of a script, which then break rule SC002.

   Can format include a setting to add a blank line at the bottom of a script, and also autofix sc002 issues.

   3 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. Paste copied table rows as seperate entities for snippets

   I would like the ability to copy a set of items then treat them as separate items for formatting purposes. For example, say I grabbed these values from a results table.

   'A'
   'B'
   'C'

   I would want to be able to paste them with the formatting I'd use for an insert, so they would look like this:

   ('A'),
   ('B'),
   ('C'),

   As it works right now though, copying and using the $PASTE$ placeholder will generate this.

   '($PASTE$)',
   '(A
   B
   C)',

   1 vote

   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  ·  Edit…  ·  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. Auto-generate MERGE comparison clauses

   One of the most tedious elements of writing T-SQL is handling of proper comparisons in the WHEN MATCHED AND ... THEN UPDATE clause of a MERGE statement.
   For example, to compare a single nullable target and destination column you should compare:

   SRC.column <> TGT.column
   OR (SRC.column IS NULL AND TGT.column IS NOT NULL)
   OR (SRC.column IS NOT NULL AND TGT.column IS NULL)

   I'm not sure on exactly how would be best to handle this but it would be great if SQL Prompt could somehow auto-populate these clauses. Or even better would be some way to generate an entire merge statement for two similar tables. When merging tables with many columns, this would be a huge time-saver. Additionally, these comparisons are highly susceptible to user-error do to the repetitive nature of the task.

   One of the most tedious elements of writing T-SQL is handling of proper comparisons in the WHEN MATCHED AND ... THEN UPDATE clause of a MERGE statement.
   For example, to compare a single nullable target and destination column you should compare:

   SRC.column <> TGT.column
   OR (SRC.column IS NULL AND TGT.column IS NOT NULL)
   OR (SRC.column IS NOT NULL AND TGT.column IS NULL)

   I'm not sure on exactly how would be best to handle this but it would be great if SQL Prompt could somehow auto-populate these clauses. Or even better would be some way to generate an entire merge statement… 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

   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

6. When typing between tics ' Intellisense is not needed.

   at some point i noticed it started recommending suggestions when typing between ''. this should be a literal string with no suggestions required

   2 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

7. Option For Aliases (Only For Custon Alias)

   Hi
   it is better to SQL prompt use only aliases define with user.

   need option in Aliases : Only For Custom Aliases

   Sorry For My Bad English

   3 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

8. Option to not square bracket aliases

   It would be nice to have an option to not but square brackets around aliases as it's our style to not do so. We find it makes the aliases unnecessarily long,since most of our aliases are 1 or 2 letters.

   For example

   SELECT
   T.[TableId],
   T.[Name]
   FROM
   [dbo].[MyTable] T

   vs

   SELECT
   [T].[TableId],
   [T].[Name]
   FROM
   [dbo].[MyTable] [T]

   Currently we have to go back and rename an alias to itself so that the square brackets go away.

   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. Subquery may return more than one row when filtering on primary key.

   At the moment a warning is given "Non-scalar subquery in place of a scalar" when trying to assign a variable to the result of a query filtered by the primary key column. In this case only one result can be returned so the warning appears inaccurate and wrapping the result in a TOP 1 { } ORDER BY statement seems an overkill just to remove the warning. This is kind of a special case however where the subquery contains only one table filtered with "=" on the primary key column, but it is a very common one.

   Example:
   DECLARE @X = (SELECT ColumnX FROM dbo.Table WHERE PrimaryKeyColumn = @Y).

   At the moment a warning is given "Non-scalar subquery in place of a scalar" when trying to assign a variable to the result of a query filtered by the primary key column. In this case only one result can be returned so the warning appears inaccurate and wrapping the result in a TOP 1 { } ORDER BY statement seems an overkill just to remove the warning. This is kind of a special case however where the subquery contains only one table filtered with "=" on the primary key column, but it is a very common one.

   Example:
   DECLARE @X… 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

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

10. Show synonym script on F12

    I would like to see the Script Object as Alter (F12) feature to work with synonyms. However, I am aware that a synonym cannot be altered - instead I suggest to generate a script containing a DROP and a CREATE statement.

    That way one could bring up the code of the referenced object by selecting the synonym, pressing F12, selecting the referenced object and pressing F12 again.

    3 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

11. Add context menu shortcuts to SQL Prompt context menu entries

    I want to be able to quickly switch between active styles.
    I'm informed that the solution to this was to add the Active Styles section of the context menu, to allow quick access to the active styles.
    That's fine as far as it goes, but that entry is very far down the menu and is only quickly accessible by mouse.

    I would like to suggest having the "Active Styles" entry changed to "&Active Styles" so that the A becomes a shortcut in the context menu; and to have each of the styles listed as &1, &2, &3 etc. in the styles submenu, so that I can get to them quickly with the keyboard.

    Hope that's clear enough. Cheers.

    I want to be able to quickly switch between active styles.
    I'm informed that the solution to this was to add the Active Styles section of the context menu, to allow quick access to the active styles.
    That's fine as far as it goes, but that entry is very far down the menu and is only quickly accessible by mouse.

    I would like to suggest having the "Active Styles" entry changed to "&Active Styles" so that the A becomes a shortcut in the context menu; and to have each of the styles listed as &1, &2, &3 etc. in the… more

    1 vote

    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  ·  Edit…  ·  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. column alias by column name

    Feature to automatically add column alias with the name of the column.
    E.g.:

    SELECT Column1
    FROM Table1 AS t1

    changes to:

    SELECT Column1 AS Column1
    FROM Table1 AS t1

    If the name can not be found add a dummy-alias like Exp1

    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

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

14. Import and Export Aliases

    It would be nice to have the ability to mass import/export aliases.

    5 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. Remove/replace String Literals

    When you code a SELECT statement as:
    SELECT EffDt AS 'EffectiveDate'
    SQL PROMPT advises that string literals as column aliases have been deprecated.
    Have an option to convert string literals, similar to Remove Square Brackets. In this case, Convert Column Aliases would either remove the apostrophes, where appropriate, or add square brackets if required (e.g. the alias contained special characters, a space or reserved word).

    3 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

16. Run Script at Cursor

    Run Script at Cursor just Oracle SQL Developer with F5 or Alt+X. Please implement this very helpful functionality.

    1 vote

    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  ·  Edit…  ·  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. Writing text within quotes

    When typing a string of text within a quote, do not replace my text with objects from the database.

    3 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

18. COLUMNPROPERTY

    COLUMNPROPERTY (https://docs.microsoft.com/en-us/sql/t-sql/functions/columnproperty-transact-sql) is missing two suggested property values that were introduced along with System-Versioned tables in SQL Server 2016.
    Please find the missing values below:
    GeneratedAlwaysType
    IsHidden

    1 vote

    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  ·  Edit…  ·  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. add trigger definition to a triggers tab on object definition box

    Currently, when hovering over table objects, and clicking on the table name mini popup, you get the object definition box, with a 'Script' and 'Summary' tab.

    The 'Script' tab has the table and index creation scripts, and the 'Summary' tab lists the column definitions.

    For tables with triggers, it would be nice to have a 'Triggers' tab that contains
    any trigger scripts for the table.

    https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/using-the-object-definition-box-and-object-tooltips

    1 vote

    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  ·  Summarize script  ·  Edit…  ·  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. inserting table adds database name

    When you select a table from the intellisense list
    Precede the table name with the database name as well
    Currently it is only inserting the schema name in front of the table name
    i.e. dbo.<table name>

    It should be <database name>.<schema name>.<table name>

    2 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