639 results found

1. Tab Groups

   Add the ability to define groups of tabs that are used regularly for different jobs. For instance--there is a group of scripts I use for month end processing and a completely different set of scripts I typically have open for daily processing. Monthly statement preparation and troubleshooting comprise another set of scripts. I'd like to be able to name groups of tabs and retrieve them based on that named grouping, while still being able to go back to what I was doing before the "interruption" that caused me to need a different set of tabs open.

   37 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 →
   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
   under review  ·  AdminTim Dalton (Product Manager, Redgate) responded

   We’re looking at improvements to tab history later during 2019 so will review this suggestion.

   Interested in demand, so do vote on the suggestion if you would find it useful.

2. Highlight a SELECT stmt and create a temp table definition from it.

   Highlight a SELECT stmt and create a temp table definition from it. You often need to create #tables and you have a select to fill it with. However, you have to either create the #table manually or do a SELECT INTO into a real table and then script it out. It would be nice to be able to just take my SELECT and be able to get the #table definition for it.

   31 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

   5 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

3. LINQ Style SQL

   What I’m proposing, would change the way we type our SQL scripts. I’m not suggesting we try to pass or force through a new SQL standard. I’m simply suggesting a new dynamic “view” of the SQL syntax, which would allow for a more natural support of intellisense. With today’s IDE’s this simply doesn’t work. Intellisense doesn’t know where to pull the “what” from. The “what” comes from the “where”, (the FROM clause).

   The underlying SQL script itself, would still comply with the SQL standards. This “view”, would perform three tasks: 1) allow the end-user to type their SQL more like LINQ, 2) rearrange current SQL scripts into that same LINQ style formatting, and 3) to translate this new format into standard compliant SQL, before executing and/or saving, within SQL Server Management Studio (SSMS).

   By LINQ style, I mean, where the “from” and “how” (on what and what type of joins are used) is defined first, with the “what” (which columns/entity attributes) last. The conditionals (the WHERE clause) and the standard grouping (the GROUP BY clause) would go between the “from/how” and the “what”.

   I would like to be able to type this and have intellisense work normally.
   FROM Order O
   JOIN OrderLine OL
   ON O.ID = OL.OrderID
   JOIN Item I
   ON OL.ItemID = I.ID
   JOIN Customer C
   ON OL.CustomerID = C.ID
   SELECT
   C.Name
   ,I.Descrption
   ,OL.Quantity
   ,OL.Price
   ,(OL.Quantity * OL.Price) “Cost”
   ,O.Number

   The transformed SQL script would be:
   SELECT
   C.Name
   ,I.Descrption
   ,OL.Quantity
   ,OL.Price
   ,(OL.Quantity * OL.Price) “Cost”
   ,O.Number
   FROM Order O
   JOIN OrderLine OL
   ON O.ID = OL.OrderID
   JOIN Item I
   ON OL.ItemID = I.ID
   JOIN Customer C
   ON OL.CustomerID = C.ID

   What I’m thinking of, is a setting tied to a toggle button on the SQL Prompt toolbar, which turns on/off this new “view”. If the toggle is turned on, the valid syntax would be the LINQ style, allowing for a more natural use of intellisense, and translate before execution and/or saving; if off, SQL Server Management Studio (SSMS) would simply work as it does now. This “view” would simply be another layer (a translator) between the text editor and the execution and/or saving of the SQL script.

   Additional, down the road, benefits:
   I’ve also read a couple different feature request to translate SQL scripts into LINQ and/or Lamda style expressions. This new “view”, or translator layer, could allow for this. A Right-Click, save as or export option could be handled here.

   What I’m proposing, would change the way we type our SQL scripts. I’m not suggesting we try to pass or force through a new SQL standard. I’m simply suggesting a new dynamic “view” of the SQL syntax, which would allow for a more natural support of intellisense. With today’s IDE’s this simply doesn’t work. Intellisense doesn’t know where to pull the “what” from. The “what” comes from the “where”, (the FROM clause).

   The underlying SQL script itself, would still comply with the SQL standards. This “view”, would perform three tasks: 1) allow the end-user to type their SQL more like… more

   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  ·  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. Keyboard macros

   Create ability to write keyboard macroses. For example I have following lines:
   column1 as varchar(100),
   column2 as int,
   ...
   column117 as uniqueidentifier primary key

   I want to get all column names. What I usually do, I am copying it to external editors that support macroses and record it on the first line with following actions:
   holdctrl+right(cursor goes to the end of column name), holdshift+pressendbutton (highlights entire row),pressdel (to delete this text),press,(to add comma at the end),pressdown(to go to the next row),presshome (to return at the beginning of the second row)
   Then I replay this macro and I have just column names.

   Create ability to write keyboard macroses. For example I have following lines:
   column1 as varchar(100),
   column2 as int,
   ...
   column117 as uniqueidentifier primary key

   I want to get all column names. What I usually do, I am copying it to external editors that support macroses and record it on the first line with following actions:
   holdctrl+right(cursor goes to the end of column name), holdshift+pressendbutton (highlights entire row),pressdel (to delete this text),press,(to add comma at the end),pressdown(to go to the next row),presshome (to return at the beginning of the second row)
   Then I… more

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

6. Load suggestions from sql files in Visual Studio/SSDT Projects

   Prompt currently needs a database connection to retrieve objects/suggestions from, which it gets from a database project's "Target Connection String".

   It would be better if prompt loaded suggestions directly from the sql files in the project without needing the database.

   105 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

   24 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
   Thomas Walsh responded

   Thank you for your suggestion.

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

   Due to a lack of recent interest in this request, we are no longer actively reviewing it and have removed it’s “Under Review” status.

   If you feel strongly about having this feature added to Prompt, please continue to vote for and comment on this request.

   Kind Regards,
   The Prompt Team

7. when aggregating add alias

   when doing simple aggregation such as sum(column), it would be nice if the column name would be aliased after the agg automatically. if this is a single column in the function then make the alias the column name. when multiple then create square brackets and move cursor into bracket after closing agg with a ")"

   13 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

8. Support for PDW (Parallel Data Warehouse, aka APS)

   Work at a company where we're adopting PDW. It would be great if I could get intellisense in PDW.

   61 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

   13 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

9. Expand a view or views referenced in a query

   I think it would be great if SQL Prompt had the functionality to expand a view that is used in a query. So if you have this schema:
   CREATE TABLE dbo.Person
   (
   PersonID INT IDENTITY(1, 1)
   PRIMARY KEY,
   LastName VARCHAR(30),
   FirstName VARCHAR(30),
   );
   GO

   CREATE TABLE dbo.Student
   (
   StudentID INT IDENTITY(1, 1)
   PRIMARY KEY,
   PersonID INT,
   StudentNo VARCHAR(100)
   );
   GO

   CREATE TABLE dbo.Class
   (
   ClassID INT IDENTITY(1, 1)
   PRIMARY KEY,
   ClassName VARCHAR(100)
   );
   GO

   CREATE TABLE dbo.ClassRoster
   (
   ClassID INT,
   StudentID INT
   );

   GO

   CREATE VIEW dbo.Students
   AS
   SELECT
   S.StudentID,
   P.LastName,
   P.FirstName,
   S.StudentNo
   FROM
   dbo.Person AS P
   JOIN dbo.Student AS S
   ON P.PersonID = S.PersonID;
   GO

   CREATE VIEW dbo.Classes
   AS
   SELECT
   C.ClassID,
   C.ClassName,
   CR.StudentID
   FROM
   dbo.Class AS C
   JOIN dbo.ClassRoster AS CR
   ON C.ClassID = CR.ClassID;
   GO

   Then you have this query:

   SELECT
   S.StudentID,
   S.LastName,
   S.FirstName,
   S.StudentNo,
   C.ClassID,
   C.ClassName,
   C.StudentID
   FROM
   dbo.Students AS S
   JOIN Classes AS C
   ON S.StudentID = C.StudentID;

   You could right-click or have a keyboard combination that say Expand Views and the query becomes:

   SELECT
   S.StudentID,
   S.LastName,
   S.FirstName,
   S.StudentNo,
   C.ClassID,
   C.ClassName,
   C.StudentID
   FROM
   (
   SELECT
   S.StudentID,
   P.LastName,
   P.FirstName,
   S.StudentNo
   FROM
   dbo.Person AS P
   JOIN dbo.Student AS S
   ON P.PersonID = S.PersonID
   ) AS S
   JOIN (
   SELECT
   C.ClassID,
   C.ClassName,
   CR.StudentID
   FROM
   dbo.Class AS C
   JOIN dbo.ClassRoster AS CR
   ON C.ClassID = CR.ClassID
   ) AS C
   ON S.StudentID = C.StudentID;

   I would find this useful when working with third party products or when coming in new to an environment as it would immediately show me the places where there are multiple references to the same table or where a view is providing some layer of filtering that I'm not aware of.

   I think it would be great if SQL Prompt had the functionality to expand a view that is used in a query. So if you have this schema:
   CREATE TABLE dbo.Person
   (
   PersonID INT IDENTITY(1, 1)
   PRIMARY KEY,
   LastName VARCHAR(30),
   FirstName VARCHAR(30),
   );
   GO

   CREATE TABLE dbo.Student
   (
   StudentID INT IDENTITY(1, 1)
   PRIMARY KEY,
   PersonID INT,
   StudentNo VARCHAR(100)
   );
   GO

   CREATE TABLE dbo.Class
   (
   ClassID INT IDENTITY(1, 1)
   PRIMARY KEY,
   ClassName VARCHAR(100)
   );
   GO

   CREATE TABLE dbo.ClassRoster
   (
   ClassID INT,
   StudentID INT
   );

   GO

   CREATE VIEW dbo.Students
   AS
   SELECT
   S.StudentID,
   P.LastName,
   P.FirstName,
   S.StudentNo
   FROM
   dbo.Person AS P
   JOIN dbo.Student AS… more

   17 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  ·  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. Indent Guides Line

    Sometime, my sql query script have too much nested condition and I need to see the indent guides line like this image:
    https://lh4.googleusercontent.com/-qmpRo6zwZTo/U6EzoIkdw7I/AAAAAAAAAYs/ctAXWq5nPwc/w725-h316-no/Untitled.png
    It would be awesome if you include this feature in this product.

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

11. Compare the contents of two tabs as text

    I would love to be able to compare the contents of two tabs (maybe by using a third party program that is run on the temp files).

    This would save me the time of having to save them down to files before using a tool like diffmerge or...

    Please consider this!

    Thx for great products.

    46 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

12. Summarize Script by Comments

    Allow an option in Summarize script to show summary by comments (for those of us that do a reasonable job of commenting code)! That would be more useful to a developer unfamiliar with specific complex code.

    10 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  ·  Summarize script  ·  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. Find unused columns in SELECT statements

    Find unused columns in SELECT statements similar to finding unused variables.
    Use case: I have some subqueries where I expanded SELECT * to now explicitly specify column names (best practice). However, only some of the columns and then used in the query process or results. I thus want the ability to have the unused columns removed from the SELECT statement.

    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  ·  Find unused variables  ·  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. 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

15. Replace all tabs with spaces

    Setting the option to use spaces instead of tabs for intending (our house policy) only works for new tab presses.
    I would like a simple action that would replace all tabs in the current document with spaces -- using the tab-to-spaces value as set in options. Sublime Text has this and I use practically every time I edit anything.

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

16. Include MERGE statement in smart rename

    When one would like to smart rename a column, the smart rename function does not update a MERGE statement. Could this be added to the smart rename feature?

    13 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

17. Add an option to position SQL Prompt popup at a screen edge, rather than at the cursor position.

    What is near the cursor tends to be data that should not be covered over. I need to see it in order to complete my statement.

    12 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

18. Format SQL Code on opening file

    It would be awsome if there was an option that would format an SQL Script automatically after opening it in SSMS / VS. So if you load a file it would be formatted automatically with your selected formatting style. It would be great too if this auto format option could be switched on and off in the Options.

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

19. Improved Tab Navigation

    Provide a better tab list for navigation than the one supplied by SSMS when there are many tabs open, for instance a resizable "navigation" window (or even a navigation tab) that easily allows filtering/grouping by server instance, database, user defined, etc.

    As a complement to grouping tabs would be to allow naming, saving, closing, and opening of a "tab group" - related queries/script files that do not make up an SSMS "project" but are used for a particular purpose or go against a particular database, etc (user determines grouping criteria, see above). Furthermore, activating a tab group would bring its members to the forefront (left), hiding a group would de-clutter the tab layouts when work is not complete but temporarily working on another issue (another tab or tab group), etc. Tab group color coding could be an alternative option for tab coloring, etc.

    Provide a better tab list for navigation than the one supplied by SSMS when there are many tabs open, for instance a resizable "navigation" window (or even a navigation tab) that easily allows filtering/grouping by server instance, database, user defined, etc.

    As a complement to grouping tabs would be to allow naming, saving, closing, and opening of a "tab group" - related queries/script files that do not make up an SSMS "project" but are used for a particular purpose or go against a particular database, etc (user determines grouping criteria, see above). Furthermore, activating a tab group would bring its… more

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

20. Make semi-colon optional at END(;)

    Semi-colons are automatically added at every END reserved key word. Make this optional.

    END(;)
    END TRY(;)
    END CATCH(;)

    This just look weird to everyone

    BEGIN
    ....
    END(;) <=== don't want it here... there's an ELSE continuation.
    ELSE
    BEGIN
    END(;)

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