272 results found

1. Add option to remove empty lines in BEGIN ... END block

   Example:

   IF 1 = 1
   begin
   SELECT
   'it does'
   print('it does')
   end
   else
   begin
   SELECT
   'it does not'

   print('it does not')
   end

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   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

2. Global Refactor (rename) tables/views/procs in dependent views/procs

   SQL Complete has an option to do renames within the current script. It would be great to support refactoring (rename) tables/views/procs/functions in dependent views/procs/funtions.

   For instance:

   CREATE TABLE dbo.Test (a INT, b INT, CONSTRAINT [PKdboTest] PRIMARY KEY (a))
   GO

   CREATE VIEW dbo.vwTest
   AS
   SELECT * FROM dbo.Test
   GO

   CREATE PROC dbo.spUpdateTest
   (
   @a int,
   @b int
   )
   as
   UPDATE dbo.Test
   SET b = @b
   WHERE a = @a
   GO

   On a separate screen (or from SSMS object explorer) choose refactor and change table name from "dbo.Test" to "dbo.GoodTableName" and SQL Complete would identify all objects where dbo.Test is referenced and would create a script to rename table, Primary Key, Foreign Key, Indexes, and views, procs, functions with new table name.

   SQL Complete has an option to do renames within the current script. It would be great to support refactoring (rename) tables/views/procs/functions in dependent views/procs/funtions.

   For instance:

   CREATE TABLE dbo.Test (a INT, b INT, CONSTRAINT [PKdboTest] PRIMARY KEY (a))
   GO

   CREATE VIEW dbo.vwTest
   AS
   SELECT * FROM dbo.Test
   GO

   CREATE PROC dbo.spUpdateTest
   (
   @a int,
   @b int
   )
   as
   UPDATE dbo.Test
   SET b = @b
   WHERE a = @a
   GO

   On a separate screen (or from SSMS object explorer) choose refactor and change table name from "dbo.Test" to "dbo.GoodTableName" and SQL Complete would identify all objects where dbo.Test is… more

   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  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. Add vertical scroll bar to 'Quick object info' hint

   Add vertical scroll bar to 'Quick object info' hint to make it possible to view the complete list of the table columns (table with more than 60 fields).

   23 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 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. Snippet - Wrap selected text in snippet

   SQL Prompt has a fantastic feature that allows selected text to be wrapped up by pressing control + selecting snippet that utilizes the SELECTEDTEXT value. This is great for wrapping up text in "Begin try", "comment blocks" and other selection oriented snippets.

   2 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  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. Format: line break before From, Where, group by & Order by

   You already allow a line break before FROM.

   Allows me to specify the number of line breaks.
   in my case i wish to use 2 line breaks after the select list
   i.e.

   SELECT
   Column1
   , Column2
   , Column3

   FROM
   SampleTable AS ST

   WHERE
   ST.Column1 > 1

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  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

6. Hide other databases from suggestions

   An option to not suggest other databases while populating the suggestion dropdown would be nice. In our system, we have discrete databases for each client, and so our development machines have hundreds of databases on them. When attempting to type a table name, it is not uncommon for SQL Complete to suggest a database name that matches the abbreviation, but for our use case this will never be ideal (queries are basically never ran across databases, and when they are we can deal with having to manually type out the database name).

   At the very least, I think it would be sufficient to alter the ranking algorithm so that the current database's tables always take precedence over other database names when providing suggestions.

   The one exception to this might be for the USE clause, but since you do contextual suggestions I don't think it would be difficult to allow suggestions of other databases in this context, but not in the FROM clause, etc.

   An option to not suggest other databases while populating the suggestion dropdown would be nice. In our system, we have discrete databases for each client, and so our development machines have hundreds of databases on them. When attempting to type a table name, it is not uncommon for SQL Complete to suggest a database name that matches the abbreviation, but for our use case this will never be ideal (queries are basically never ran across databases, and when they are we can deal with having to manually type out the database name).

   At the very least, I think it would… more

   2 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   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

7. Simplify snippet editing with variables

   SQL Prompt allows quick editing of snippets by typing a variable name wrapped in dollar signs and automatically adds this to the bottom list of variables to edit. This makes editing a snippet very easy, and doesn't require as many steps as the current SQL complete UI for adding custom variables. Consider evaluating using this type of simplified editing experience.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  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

8. Integrate with CodeCompare Free/Pro

   Permitir comparar dos archivos o más objetos por selección; de bases de datos diferentes o de servidores diferentes.

   9 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   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

9. copy to code

   After I create a query in Sql Management Studio, what I usually do is copy the sql to code. I'm programming in c# and when I copy the sql to code, I must add parentheses at the start and the end of each line with also a '+' character to tells compiler to combine line.

   A very beautiful feature would be to add a shortcut to copy the sql into the clipboard but with these parentheses and '+' character. After that, I just simply have to paste it without error directly into my code.

   Another very beautiful feature would be to have exactly the opposite; a 'paste from code' that automatically remove all parentheses and '+' character that allow me to execute the sql query without additionnal manual step.

   After I create a query in Sql Management Studio, what I usually do is copy the sql to code. I'm programming in c# and when I copy the sql to code, I must add parentheses at the start and the end of each line with also a '+' character to tells compiler to combine line.

   A very beautiful feature would be to add a shortcut to copy the sql into the clipboard but with these parentheses and '+' character. After that, I just simply have to paste it without error directly into my code.

   Another very beautiful feature would be… more

   14 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   4 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

10. Filter autocomplete list by any substring, not just word initials

    Today, SQL Complete supports filtering the AutoComplete list by typing the initials of CamelCase identifiers. In Resharper, you can type any sequence of characters from the member you are looking for, and the autocomplete list is filtered by any members which contain the character you typed, as long as they appear in the same order you typed. This makes it easier to find what you are looking for, because it's easier to type parts of words than to remember the exact words and their initials.

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  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

11. Implement ability to show objects in completion list only for specific databases

    It would be nice to have an option to limit intellisense to either 1) the currently selected database or 2) a pre-defined set of databases. That way I don't have irrelevant database object names showing up in the intellisense pop-up.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    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

12. When hovering over SP, display whether it has default values or not

    Is it possible that when i hover over an SP, that i see if the parameters have default values or not?

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    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

13. When Formatting, Place Short Queries on a Single Line

    I would like the option to specify that queries under a certain number of characters be formatted to be on a single line. This would also apply to subqueries so that if they are over the specified limit it follows the formatting rules already in place for subqueries but places simple subqueries on a single line.

    So

    SELECT
    *
    FROM
    TABLE
    WHERE
    COL1 = 5;

    would become

    SELECT * FROM TABLE WHERE COL1 = 5;

    and

    SELECT
    COL1,
    COL2,
    COL3,
    COL4,
    CASE WHEN COL5 = 50 THEN 'A' ELSE 'B' END
    FROM
    TABLE
    WHERE
    COL1 IN (
    SELECT
    COLB
    FROM
    TABLE2);

    becomes

    SELECT
    COL1,
    COL2,
    COL3,
    COL4,
    CASE WHEN COL5 = 50 THEN 'A' ELSE 'B' END
    FROM
    TABLE
    WHERE
    COL1 IN (SELECT COLB FROM TABLE2);

    If the entire query, subqueries and all, fits into the specified number of characters it should also be placed on a single line so it wouldn't take statements like this -

    SELECT Col1 FROM TABLE WHERE COL1 IN (SELECT COLA FROM TABLE2);

    and split them up according to the formatting rules.

    I would like the option to specify that queries under a certain number of characters be formatted to be on a single line. This would also apply to subqueries so that if they are over the specified limit it follows the formatting rules already in place for subqueries but places simple subqueries on a single line.

    So

    SELECT
    *
    FROM
    TABLE
    WHERE
    COL1 = 5;

    would become

    SELECT * FROM TABLE WHERE COL1 = 5;

    and

    SELECT
    COL1,
    COL2,
    COL3,
    COL4,
    CASE WHEN COL5 = 50 THEN 'A' ELSE 'B' END
    FROM
    TABLE
    WHERE
    COL1 IN (
    SELECT
    COLB
    FROM… more

    2 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  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. Goto Type/Database Object

    Resharper, a popular addon for visual studio has a nifty feature where you can hit ctrl+t to open a compact search window where you can type part of a type name, and a list of clickable suggestions is presented as you type.

    http://www.jetbrains.com/resharper/features/navigation_search.html#Go_to_Type

    It would be quite handy to have something similar for Management Studio.
    Clicking any of the matches could open a new query window with an ALTER statement prepared.

    133 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    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

15. Do _NOT_ hijack Ctrl+S. It is not your key combo to mess with.

    Ctrl+S is not to be hijacked in the default install under any circumstances.

    2 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    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
    AdminDevart (_, Devart) responded

    Could you please let us know after what actions exactly it started happening and what exactly happens when you press the mentioned key combination?

    Please also specify what versions and editions of dbForge SQL Complete, SSMS or VS you are using.

16. Add "Copy Current Statement (Ctrl+Shift+C)" & "Cut Current Statement (Ctrl+Shift+X)"

    Execute Current Statement is a great feature to test out a statement currently being worked. Sometimes I like to break a statement out to its own query window for further development.
    Copy (or Cut) Current Statement would work just like Execute Current Statement except it would copy (or cut) the statement to clipboard instead of executing it.

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  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. Allow formating on ctl-K, ctl-F to be disabled.

    I have another tool I'd prefer to use for formatting, but SQL Complete captures the "ctl-k, ctl-f" clicks, preventing me from using the other tool.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  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
    AdminDevart (_, Devart) responded

    Could you please let us know what version of SSMS or VS you are using?

    Please note that in some versions Visual Studio or SSMS you can redefine shortcuts for the commands of dbForge SQL Complete (the command contain ‘SQLComplete’) in the ‘Environment → Keyboard’ section of the ‘Options’ window that can be invoked by selecting ‘Tools → Options’ from the main menu.

    Also, please let us know what tool you prefer for formatting and why you chose it over dbForge SQL Complete.

    You can reply straight to our support system at supportATdevartDOTcom

18. Ability to clear results of Output window

    It would be nice to be able to clear the results of the output window

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    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

19. Navigating to errors on formatting from Output window

    When running format document and there are syntax errors, it would be great if you could double click the error in the output window and it would take you to the error.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    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

20. Force capital word

    There are some identifiers and variables we'd like to force with CAPTITALS regardless of the formatting rules.

    Similar to the "General > Available prefixes:", could we have a "Force word formatting" option where we can enter these special word types? ie. TranSid ==> TRANSID

    6 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  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