277 results found

1. query history starts at Open Queries;

   I would like a config open so that the dropdown of queries starts at OPEN QUERIES not all queries

   also, I would like it when my mouse hovers over the magic tab button for it to just expand... the extra click makes it less magic

   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

   4 comments  ·  Tab history  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   We’ve released SQL Prompt 6 which includes this.

2. Better work with temporary tables variables

   The script below does not generate the correct sql syntax when adding a @table name into a subselect

   DECLARE @temptable AS TABLE (recid INT)

   DECLARE @mytable AS TABLE (contractid INT)

   INSERT INTO @mytable
   ( contractid )
   VALUES ( 1 -- contractid - int
   )

   ---> type @my -> then tab
   --> the table is predefined with brackes wich is wrong for a @table
   -> the below row is the result

   SELECT * FROM @temptable WHERE recid IN (SELECT * FROM [@mytable])

   11 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   This case should be fixed in the latest release of Prompt (6.3). Let me know if you’re still having any problems with it.

3. Show Long file names in Query History in Tool Tip

   Hi,

   Thanks for your last changes!

   In addition, I have sometime Long file names where only looking on their Name tail or according to their full path, I can decide which one is the relevant.
   Could you add in Query History a Tool Tip when hovering above the File Name with Full Name, Path, Last Closed, Last Connection details, etc.?

   THNX
   Jermy

   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  ·  Tab history  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   We’ve released SQL Prompt 6 which includes this.

4. Bulk Delete old tabs

   It would be great to be able to bulk delete old or unneeded tabs from Tab History. Right now, I have to delete it one by one which is an endless task.

   8 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Tab history  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   We’ve released SQL Prompt 6 which includes this.

5. SQL Tab Magic - When searching query history the text in the preview pane jumps to the left

   Hi,

   First, I like the new design, and thank you for make it available for SSMS 2012.
   I have 2 problems:
   1. I missing the Option button (I don't wont it to open recently closed queries on start-up).
   2. When I'm searching for term in the Query History dialog, and hovering above one of the files in the left pane, its query text in the preview pane jumps to the somewhere in the file and move a bit to the left. I assumes it suppose to jump to the first match, but, it is not always even in the frame. If you want to scroll to understand the context, you must not hover on other query, when you move the mouse to the right pane.

   THNX
   Jermy

   Hi,

   First, I like the new design, and thank you for make it available for SSMS 2012.
   I have 2 problems:
   1. I missing the Option button (I don't wont it to open recently closed queries on start-up).
   2. When I'm searching for term in the Query History dialog, and hovering above one of the files in the left pane, its query text in the preview pane jumps to the somewhere in the file and move a bit to the left. I assumes it suppose to jump to the first match, but, it is not always even in the frame.… more

   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  ·  Tab history  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   We’ve released SQL Prompt 6 which includes a fix for these.

6. Recognize double quotes for object names in the same way as square brackets.

   Please enable SQL Prompt to have the same behavior with double quotes as with square brackets.

   For example, typing:
   SELECT * FROM [MyTable]
   will allow the expansion of the asterisk, while
   SELECT * FROM "MyTable"
   does not.

   SET QUOTED_IDENTIFIER is ON by default. Also, many Oracle "converts" use the format "SchemaName"."TableName".

   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  ·  Qualify object names  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   This is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/

7. Unwrap sp_executesql

   Frequently I need to debug application generated SQL obtained via Profiler. Parameterized queries are often implemented with sp_executesql.

   I love using Format SQL to make a single line monster query into something I can actually read. But when it's stuck in an spexecutesql call the format function doesn't touch it. I have to:
   Remove "Exec spexecutesql".
   Remove the apostrophes around the query SQL. For big queries this is really painful, especially if the query itself contains apostrophes.
   Remove the apostrophes around the parameter defenitions.
   Move the parameter definitions to the top and add a DECLARE.
   Move the parameter value assignments below the declare and add a SELECT.

   Slightly trivial example
   exec sys.sp_executesql N'select * from sys.objects where [name]=@objectName and [type]=@objectType', N'@objectName SYSNAME, @objectType CHAR(2)', @objectName = N'sysrscols', @objectType = 's'

   I would like this feature to transform it to
   DECLARE @objectName SYSNAME, @objectType CHAR(2)
   SELECT @objectName=N'sysrscols', @objectType='s'
   select * from sys.objects where [name]=@objectName and [type]=@objectType

   Then regular formatting rules would apply.
   The kinds of queries I regularly debug much bigger and complex. You can imagine how much pain this would save me :)

   Frequently I need to debug application generated SQL obtained via Profiler. Parameterized queries are often implemented with sp_executesql.

   I love using Format SQL to make a single line monster query into something I can actually read. But when it's stuck in an spexecutesql call the format function doesn't touch it. I have to:
   Remove "Exec spexecutesql".
   Remove the apostrophes around the query SQL. For big queries this is really painful, especially if the query itself contains apostrophes.
   Remove the apostrophes around the parameter defenitions.
   Move the parameter definitions to the top and add a DECLARE.
   Move the parameter… more

   18 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  ·  Format SQL  ·  Delete…  ·  Admin →
   completed  ·  Andrei Rusitoru responded

   This feature was released in version 7.3 of SQL Prompt.

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

   Kind Regards,
   The Prompt Team

8. Unformat SQL

   It would great if there was an un-format SQL command, which would basically un-format the SQL by removing all the carriage returns, tabs, extra spaces, etc. I know it seems odd, but we have several applications that use the SQL via external files, so the formatting will not work, and we end up manually removing all the formatting.

   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 →
   completed  ·  Aaron Law responded

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

9. Please add support for Service Broker Objects
   4 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 →
   completed  ·  Aaron Law responded

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

10. Improve "read ahead" for variables

    I find that in longer stored procedures, declared variables often don't show up as I start to type them. E.g. typing @ towards the beginning of the sp shows me a list of the variables, however if I'm further down in the proc, they ofter are not listed.

    15 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 →
    completed  ·  Aaron Law responded

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

11. Surround templates added to snippet manager.

    So you could highlight a column and surround it with isnull() for example.
    Or surround a sql query and surround it with begin and end.

    11 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Script object as alter  ·  Delete…  ·  Admin →
    completed  ·  Aaron Law responded

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

12. Performance: Moving the Cursor e.g. over functions (showing popups), in huge scripts is slow
    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  ·  Intellisense  ·  Delete…  ·  Admin →
    completed  ·  Aaron Law responded

    We’ve just released SQL Prompt 6.1 which shouldn’t slow down SSMS with huge scripts.

13. marker on pairs of BEGIN and END on code

    marker on pairs of BEGIN and END on code

    38 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 →
    completed  ·  Aaron Law responded

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

14. Code sniffing

    Hows about Code sniffing? For checking code compliance with user defined standards. Like checking column names conform to a defined standard, warnings on bad practices etc. You know all those little annoying things like no clustered index, use of cursors instead of set based ops, use of Select * or of Insert into tableA values (a,b,c).

    All driven by user defined rules? With larger dev teams the standards docs always left to the side. If it could work on input and in some sort of batch mode (on sql source control check in?) it would be nice.

    I've been looking around but unable to find any products like this for SQL server, there looks to be a good one for PHP though. all it need do is use blue squiggleys to highlight to the user with tooltips to describe the breach.

    Hows about Code sniffing? For checking code compliance with user defined standards. Like checking column names conform to a defined standard, warnings on bad practices etc. You know all those little annoying things like no clustered index, use of cursors instead of set based ops, use of Select * or of Insert into tableA values (a,b,c).

    All driven by user defined rules? With larger dev teams the standards docs always left to the side. If it could work on input and in some sort of batch mode (on sql source control check in?) it would be nice.

    I've been looking… more

    14 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Intellisense  ·  Delete…  ·  Admin →
    completed  ·  Frederico Jeronimo responded

    We’re happy to announce that we introduced code analysis in SQL Prompt 9+. For additional information see: https://documentation.red-gate.com/sp9/analyzing-your-code

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

    If you have any ideas regarding improvements to Prompt’s code analysis, please feel free to open further UserVoice requests.

    Thank you for your help!

    Kind regards,

    The Prompt Team

15. Execute current statement/block

    It would be greate if you could make an option to Execute current statement/block/all staments from top to current stament (current=where the cursor located) when clicking Ctrl + Alt + F5/Ctrl + Shift + F5/Alt + Shift + F5.
    So, if the the cursor located in a the middle of long script, and I'm clicking Ctrl + Alt + F5 it will execute the currnt statment like if I would have select the current statement and click F5.
    Same for Ctrl + Shift + F5 and Current block and for Alt + Shift + F5 and all staments from top to current stament.
    THNX

    It would be greate if you could make an option to Execute current statement/block/all staments from top to current stament (current=where the cursor located) when clicking Ctrl + Alt + F5/Ctrl + Shift + F5/Alt + Shift + F5.
    So, if the the cursor located in a the middle of long script, and I'm clicking Ctrl + Alt + F5 it will execute the currnt statment like if I would have select the current statement and click F5.
    Same for Ctrl + Shift + F5 and Current block and for Alt + Shift + F5 and all staments from top… more

    43 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

    9 comments  ·  User interface  ·  Delete…  ·  Admin →
    completed  ·  Aaron Law responded

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

16. Do not indent FROM and WHERE clauses

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

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    completed  ·  Andrei Rusitoru responded

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

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

    Thank you for your help!

17. 2012 keywords

    2012 keywords like LEAD( LAG( etc.

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    completed  ·  Aaron Law responded

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

18. Format CTE

    Allow users to specify how CTEs should be formatted. Right now I get:

    WITH cte
    AS (
    SELECT
    Title
    ,FirstName
    ,LastName
    FROM
    isales.dbo.salesteam
    )
    SELECT
    Title
    ,FirstName
    ,LastName
    FROM
    cte

    What I would like is:

    WITH cte
    AS
    (
    SELECT
    Title
    ,FirstName
    ,LastName
    FROM
    MyTable
    )
    SELECT
    Title
    ,FirstName
    ,LastName
    FROM
    cte

    26 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 →
    completed  ·  Andrei Rusitoru responded

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

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

    Thank you for your help!

19. Change formatting of IF statements.

    When an IF is short and does not have a BEGIN END on it, have it format to a single line.

    Right now if you have

    IF @Parameter1 = 0
    RETURN -1
    IF @Parameter2 = 0
    RETURN -2

    I would like it to be:

    IF @Parameter1 = 0 RETURN -1
    IF @Parameter2 = 0 RETURN -2

    which would make it more compact.

    23 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 →
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 8 of SQL Prompt.

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

    Kind Regards,
    The Prompt Team

20. Make intellisense recognize procedure/function valriables

    Intellisense does not seem to recognize variables declared within the current stored proc. This would be helpful.

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Intellisense  ·  Delete…  ·  Admin →
    completed  ·  Aaron Law responded

    This was fixed a while back – I’m sorry for not updating your request sooner!

    You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/