13 results found

1. "Invalid object" warning with statement that uses linked server

   The intellisense will suggest the object as I am typing the linkedserver.db.schema.table in a statement. However, once the statement has been created, the object/columns etc. are underlined in red and hovering over displays the "Invalid object" warning

   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
   declined  ·  AdminAdrian B (n/a, Redgate) responded

   Thanks for your feedback. This sounds more like a bug, although we’re not currently aware of it.

   Please could you raise a support ticket with recreation steps at https://redgatesupport.zendesk.com ?

   Thanks,

   The Prompt Team

2. SQL Prompt code completion completely broken for any query after an UPDATE query with USE HINT syntax

   SQL Prompt code completion is broken if you use the OPTION ( USE HINT ( ) ) syntax with an update query. To make matters worse, if you are writing a stored procedure, the code completion tools remain broken for every query following the UPDATE statement as well.

   This is on SQL Prompt v9.4.15.8960 with SQL Server Management Studio v17.9.1.

   Here is a repro:
   CREATE OR ALTER PROCEDURE dbo.TestThis
   AS
   BEGIN
   SET NOCOUNT ON;

   DECLARE @var int;

   -- try to do any code completion after this statement
   -- only snippets will work
   UPDATE TestTable
   SET WatchThisBreak = 1
   OPTION( USE HINT( 'FORCEDEFAULTCARDINALITY_ESTIMATION' ));

   END;

   SQL Prompt code completion is broken if you use the OPTION ( USE HINT ( ) ) syntax with an update query. To make matters worse, if you are writing a stored procedure, the code completion tools remain broken for every query following the UPDATE statement as well.

   This is on SQL Prompt v9.4.15.8960 with SQL Server Management Studio v17.9.1.

   Here is a repro:
   CREATE OR ALTER PROCEDURE dbo.TestThis
   AS
   BEGIN
   SET NOCOUNT ON;

   DECLARE @var int;

   -- try to do any code completion after this statement
   -- only snippets will work
   UPDATE TestTable
   SET WatchThisBreak = 1
   OPTION( USE… 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

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

3. Format clipboard for IN query

   Often we'll do a query e.g. SELECT Id from Table where param LIKE '%Foo%'

   Then we'll want to copy and paste those Ids in to a separate query

   DELETE FROM Table WHERE Id in (.......)

   It would be good if there was a way SQL Prompt could help format the clipboard paste into a comma-separated list.

   (I appreciate this example would be simple to refactor as a JOIN)

   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  ·  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
   declined  ·  Thomas Walsh responded

   Thank you for your suggestion.

   We’ve reviewed this as part of our UserVoice triage.

   Currently, we have no plans to implement this feature in the near future, as it does not align with our current work.

   Kind Regards,
   The Prompt Team

4. Select Statements - WHERE clause value suggestion

   I would like to get suggestions for the WHERE query value. For example, when querying a dimension table, I would like to receive a selection box with the possible values to enter.

   empid firstname lastname

   ---

   1 Test User
   
   2 Dummy User

   Select * from Table
   Where firstname= [Suggestion Box displays the values "Test" and "Dummy" to pick]

   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  ·  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
   declined  ·  Thomas Walsh responded

   Thank you for your suggestion.

   We’ve reviewed this as part of our UserVoice triage.

   Currently, we have no plans to implement this feature in the near future, as it does not align with our current work.

   Kind Regards,
   The Prompt Team

5. Don't suggest join keys I've already used

   After I type
   SELECT * FROM sys.indexes i
   INNER JOIN sys.partitions p
   ON i.indexid = p.indexid
   AND

   the IntelliSense still suggests me i.indexid = p.indexid which I've already used. These duplicates can become pretty annoying when multiple columns are used for joining

   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

   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
   declined  ·  Thomas Walsh responded

   Thank you for your suggestion.

   We’ve reviewed this as part of our UserVoice triage.

   Currently, we have no plans to implement this feature in the near future. However, if there is sufficient demand in the future, we will revisit it.

   Please feel free to send us any additional feedback on these topics by commenting here.

   Kind Regards,
   The Prompt Team

6. keep getting Sql server management studio IsBusy, because of sql prompt

   sometimes its counter productive, messing up in the way of regular intellisense

   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

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

   Hi Anvoy,

   Sorry to hear you’re having issues with SQL Prompt! This sounds more like a bug than a feature request so I’m going to close this idea – our support site would be a better place to log it: https://redgatesupport.zendesk.com/hc/en-us/requests/new
   please include the version of SQL Prompt that you’re using and detailed recreation steps.

   Thanks,
   Aaron.

7. Intellisense improvement : Write the FROM automatically for the user based on the SELECT

   The idea is that we don't have to go back with the cursor and can always type forwards, not interrupting our flow/thinking

   For Example,

   User types:
   SELECT Master.Active,

   Prompt now makes it

   SELECT m.Active -- Cursor stays here
   FROM Master m

   We still start with the SELECT but mention the table which is an indication to Prompt to wrote the FROM automatically after that.

   Now we start with the from and go back to the select which is cumbersome if you have to do it 100 times a day.

   This feature is also more natural to find because the developer will at some point type the table to get intellisense for the columns
   and discover that Prompt took care of the rest.

   We could even go a bit further and let Prompt write the join to a second table if there is only one foreign key to it (99% of the cases) :

   User continuous typing with cursor at the same position

   SELECT m.Active, Detail.Description
   FROM Master m

   Prompt now types:

   User Types
   SELECT Master.Active, d.Description
   FROM Master m
   JOIN Detail d ON d.MasterID = m.ID

   A similar idea is described below but suggests to start with the FROM which does not feel natural
   https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/3986501-auto-complete-for-pk-column-values-example-sel

   The idea is that we don't have to go back with the cursor and can always type forwards, not interrupting our flow/thinking

   For Example,

   User types:
   SELECT Master.Active,

   Prompt now makes it

   SELECT m.Active -- Cursor stays here
   FROM Master m

   We still start with the SELECT but mention the table which is an indication to Prompt to wrote the FROM automatically after that.

   Now we start with the from and go back to the select which is cumbersome if you have to do it 100 times a day.

   This feature is also more natural to find because the developer… more

   19 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
   declined  ·  Thomas Walsh responded

   Thank you for your suggestion.

   We’ve reviewed this as part of our UserVoice triage.

   Currently, we have no plans to implement this feature in the near future. However, if there is sufficient demand in the future, we will revisit it.

   Please feel free to send us any additional feedback on these topics by commenting here.

   Kind Regards,
   The Prompt Team

8. Can "Swap order of columns in join clauses" be enabled automatically if upgrading from an earlier version e.g. 5

   WIth the change in v6 to default to

   SELECT * FROM table1
   INNER JOIN table2
   ON table2.id = table1.id

   whereas previous versions used this format.

   SELECT * FROM table1
   INNER JOIN table2
   ON table1.id = table2.id

   If upgrading from an earlier version, can either the swap order option be enabled or at least the user warned during installation that the intellisense options have changed and that queries will be formatted differently.

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

   Thanks for your suggestion Kieron.

   In adding this new option, we set the default column order to what we think will be the most useful. If you prefer the old behaviour, select the new option – your option preferences will be persisted when you install new versions of SQL Prompt.

9. Allow starting with FROM clause first to make intellisense and query building more natural

   Allow starting a query with the FROM clause (ala LINQ) and provide intellisense normally. I would continue normally, right up to the point the user types the select update or delete keywords, at which point you either automagically reposition the keword and cursor to the top of the query, or allow the user to finish and then prompt for query restructuring. This would completely do away with the mucking around of doing a ssf and then going back later to fill in the list! In fact, I'd take it a step further and offer to restructure poorly written queries..e.g., If GROUP BY, HAVING, WHERE or ORDER BY are in the wrong place, why not prompt to correct the syntax? Oh how lazyness can serve as mother of invention!

   Allow starting a query with the FROM clause (ala LINQ) and provide intellisense normally. I would continue normally, right up to the point the user types the select update or delete keywords, at which point you either automagically reposition the keword and cursor to the top of the query, or allow the user to finish and then prompt for query restructuring. This would completely do away with the mucking around of doing a ssf and then going back later to fill in the list! In fact, I'd take it a step further and offer to restructure poorly written queries..e.g., If… 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

   3 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
   declined  ·  Thomas Walsh responded

   Thank you for your suggestion.

   Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

   If you feel strongly about it, we encourage you to create a new request.

   Thanks,

   The Prompt Team

10. Enable SQL Prompt when in the SSMS editor for "right-click, edit table"

    When we right-click a table in the object explorer and choose "Edit top 200 rows" (SS2008 onwards), the SQL editor is not the T-SQL script editor so SQL Prompt is unavailable. It would prove VERY helpful to have full SQL Prompt "Suggestions" functionality available.

    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
    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

11. Suggestions based on ranking of user input

    Track how often columns are joined by the user, and suggest based on common joins (for that user), not just foreign key/name/datatypes.

    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
    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

12. Automatic Alias from Table Name

    Rather than individually defining aliases per table, add an option to use capitalised letters of tables/views to define an alias.

    eg.

    Customer = C
    mem_Membership = M

    cus_StateCustomer = SC

    aReallyLongTableName = RLTN

    view_CustomerMembership = CM

    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

    3 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
    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

13. Suggest Alias Even When Table Doesn't Exist

    When you have a table in a FROM clause that is aliased, but the table doesn't exist, or is a temp table where the creation isn't in the script or is commented out SQL Prompt doesn't even include the alias as a suggestion. I think it should.

    You can see my example in this forum post: http://www.red-gate.com/MessageBoard/viewtopic.php?p=46775#46775

    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  ·  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
    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team