674 results found

1. open source sql prompt's formatting module.

   open source sql prompt's formatting module.

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

   Submit Rating

2. Change the activation model to allow easier portability

   As a consultant I move around to many computers. I depend on this product, but it is often a chore to keep track of where it is active. It would be a real quality of life improvement if I could just login to the machine I'm using and type in my redgate creds to activate sql prompt and get on with it. So often I'm running into an activation error, followed by a support call to find where the product is in use, then deactivate it, the activate on the new machine repeat, repeat, repeat...

   I understand you make money based on activations, but it would be nice if we could find a middle ground where you can still turn a profit, but I don't need to jump through a few hoops when I want to use the product someplace new.

   As a consultant I move around to many computers. I depend on this product, but it is often a chore to keep track of where it is active. It would be a real quality of life improvement if I could just login to the machine I'm using and type in my redgate creds to activate sql prompt and get on with it. So often I'm running into an activation error, followed by a support call to find where the product is in use, then deactivate it, the activate on the new machine repeat, repeat, repeat...

   I understand you make money… 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

   Submit Rating

3. Support 'FROM BINARY' in CREATE CERTIFICATE

   Support 'FROM BINARY' in CREATE CERTIFICATE

   Since SQL Server 2012 there is an option to specify an ASN-encoded binary certificate when doing ‘CREATE CERTIFICATE’. Alongside CERTENCODED() and CERTPRIVATEKEY() this makes for a good way to transfer certificates generated on SQL server to other stages.

   Your formatting engine however does not recognize the BINARY-parameter of said statement. Please include it as valid syntax.

   Examples (non-working because the certifcates are fake – but you are free to generate your own; note that passwords are optional):

   CREATE CERTIFICATE [TestCert] AUTHORIZATION [dbo]

   FROM BINARY = 0x42

   WITH PRIVATE KEY ( BINARY = 0x42, DECRYPTION BY PASSWORD='', ENCRYPTION BY PASSWORD='' )

   ACTIVE FOR BEGIN_DIALOG = ON;

   GO

   CREATE CERTIFICATE [TestCert] AUTHORIZATION [dbo]

   FROM BINARY = 0x42

   ACTIVE FOR BEGIN_DIALOG = ON;

   GO

   Support 'FROM BINARY' in CREATE CERTIFICATE

   Since SQL Server 2012 there is an option to specify an ASN-encoded binary certificate when doing ‘CREATE CERTIFICATE’. Alongside CERTENCODED() and CERTPRIVATEKEY() this makes for a good way to transfer certificates generated on SQL server to other stages.

   Your formatting engine however does not recognize the BINARY-parameter of said statement. Please include it as valid syntax.

   Examples (non-working because the certifcates are fake – but you are free to generate your own; note that passwords are optional):

   CREATE CERTIFICATE [TestCert] AUTHORIZATION [dbo]

   FROM BINARY = 0x42

   WITH PRIVATE KEY ( BINARY = 0x42, DECRYPTION… 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

   Submit Rating

4. Add option in context menu to "Open In Browser"

   When the grid outputs a link as its value, right clicking the cell would provide an option to "Open In Browser"
   ...
   Additionally, this same functionality could be customizable (perhaps a customize context menu section within SQL Prompt options) to allow for other applications, wherein the highlighted/cell value is passed as a parameter to a given application. This would be similar to the External Tools, which is provided within SSMS, but having that option right there in the context menu would be gold.

   So, in the case of a URL, I right click the cell, choose Open In Browser, and then browser fires up with my URL.

   When the grid outputs a link as its value, right clicking the cell would provide an option to "Open In Browser"
   ...
   Additionally, this same functionality could be customizable (perhaps a customize context menu section within SQL Prompt options) to allow for other applications, wherein the highlighted/cell value is passed as a parameter to a given application. This would be similar to the External Tools, which is provided within SSMS, but having that option right there in the context menu would be gold.

   So, in the case of a URL, I right click the cell, choose Open In Browser, and… 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

   Submit Rating

5. Stop resetting defaults (like paths) with every Update

   I spent a lot of time setting up custom directories for various products/features and its frustrating how SQL Prompt resets this with each new update forcing me to go back and change all these paths/defaults back to what they were before.

   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

   Submit Rating

6. Vertical rivers - cobol style

   When writing SQL I don't think procedurally, which means I don't think about nested, indented "blocks" unless I'm actually using some procedural style SQL extensions like try/catch, if, case (which is a little procedural expression inside a set based statement), and so on.

   Because of this, I like to align various different "types of things" in a statement to create vertical rivers.

   So, for example, insert, update, select, from, join, where, group by, having, and order by are all aligned on the left. You might think of this as "column 1 - sql keywords".

   Then come column names, table names (inside from/join), and expressions (inside where, having, order by). All of this is "column 2". My formatting for insert target columns is hard to justify, but it's basically the table name is left aligned to column 2, with the target columns indented.

   Table aliases are "column 3".

   Join conditions ("on" and "and") are column 4. Complex joins which turn into "producural-like" if nestings are hard to set a rule for.

   This results in a style with "vertical rivers" through the code. It's easy to scan down quickly and see which columns are used, which tables are used, what the aliases are, etc.

   If a statement is nested (eg, a subquery), then the subquery gets its own "column 1, column 2", and so on.

   I believe Jeff Moden uses a similar style. The result looks like this:

   https://imgur.com/a/1Da9QzO

   I don't know how many others work this way, but I thought I'd throw it out there. It's currently not possible to set this up with SQL prompt.

   When writing SQL I don't think procedurally, which means I don't think about nested, indented "blocks" unless I'm actually using some procedural style SQL extensions like try/catch, if, case (which is a little procedural expression inside a set based statement), and so on.

   Because of this, I like to align various different "types of things" in a statement to create vertical rivers.

   So, for example, insert, update, select, from, join, where, group by, having, and order by are all aligned on the left. You might think of this as "column 1 - sql keywords".

   Then come column names, table names… 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  ·  Format SQL  ·  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

   Submit Rating

7. Aliases

   On SQL Prompt Aliases section I would like to have on custom aliases when I add a new a dropdown or a list view where I can pick object instead of me writing the object name. it would be even better if it has an option to show only object not already added with alias.

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

   Submit Rating

8. Make a

   Similar to visual studio code, it would be good to have a find and replace all occurrences by highlighting what you would like to replace. This would then give you the option to type in what you want to replace. I know Sql Server has a find and replace function, however I just really like this functionality and think it would be a great addition to SQL prompt

   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

   Submit Rating

9. supporting python and R syntax
   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

   Submit Rating

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

    Submit Rating

11. Arithmetic expressions - format consistently with logical expressions

    Arithmetical expressions and compound logical expressions all consist of operations and expressions with parentheses and orders of precedence. All of these should have the options for aligning operands, aligning parentheses, adding parentheses to make the default orders of precedence explicit. All expressions are subordinate to clauses so they should be indented under WHERE, ON, SELECT, WHEN.

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

    Submit Rating

12. Place space before END when collapsing shorter case statements

    When collapsing CASE expressions shorter then XXX, the END has no space if there is a preceding parenthesis.

    Example1 = CASE t1.Col004 WHEN 1 THEN t1.Col006 END,
    Example1 = CASE t1.Col004 WHEN 1 THEN TRY_CONVERT(int, t1.Col006)END,

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

    Submit Rating

13. Schema Folders

    Please introduce Schema-Folders in SQL-Server Object Explorer
    as shown in
    https://github.com/nicholas-ross/SSMS-Schema-Folders

    Or make SQL-Prompt working together with
    https://github.com/nicholas-ross/SSMS-Schema-Folders.

    The Features "Show in Object Eplorer" and "Skript Object as ALTER"
    don't work together with Nicolas Ross' Schema Folders

    0 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  ·  Platform Support  ·  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

    Submit Rating

14. Add support for SSMS preview candidates

    Some people uses the latest versions of SSMS. I'd like to see it in non-release versions, maybe not fully supported yet.

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

    Submit Rating