6 results found

1. Don't alias objects with reserved words

   CREATE TABLE dbo.GrumpyOld (col1 int)

   SQL Prompt will alias the table as GO, which causes problems because it's a batch separator.

   Thanks!

   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  ·  Qualify object names  ·  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

2. decimal

   Hi, It would be great, if you add precision and scale on numeric/decimal data types - column hint and table summary.

   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

   2 comments  ·  Qualify object names  ·  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

3. VALUES

   Correctly qualify the Table Value Constructor.

   I frequently use a TVC to find the Max value among several values on a single row, as with the following:

   ;WITH MyCte AS (SELECT 1 AS a, 2 AS b, 3 AS c)
   SELECT
   MyCte.a,
   MyCte.b,
   MyCte.c,
   HighestNumber = (SELECT MAX(Value.Val) FROM (VALUES (MyCte.a), (MyCte.b), (MyCte.c)) AS Value(Val))
   FROM MyCte

   When I qualify object names within that script, it incorrectly tries to add the 'Value' as a qualifier within the constructor:

   ;WITH MyCte AS (SELECT 1 AS a, 2 AS b, 3 AS c)
   SELECT 
       MyCte.a,
       MyCte.b,
       MyCte.c,
       HighestNumber = (SELECT MAX(Value.Val) FROM (VALUES (MyCte.a), (MyCte.b), (MyCte.c)) AS Value(Value.Val))
   FROM MyCte
   

   Correctly qualify the Table Value Constructor.

   I frequently use a TVC to find the Max value among several values on a single row, as with the following:

   ;WITH MyCte AS (SELECT 1 AS a, 2 AS b, 3 AS c)
   SELECT
   MyCte.a,
   MyCte.b,
   MyCte.c,
   HighestNumber = (SELECT MAX(Value.Val) FROM (VALUES (MyCte.a), (MyCte.b), (MyCte.c)) AS Value(Val))
   FROM MyCte

   When I qualify object names within that script, it incorrectly tries to add the 'Value' as a qualifier within the constructor:

   ;WITH MyCte AS (SELECT 1 AS a, 2 AS b, 3 AS c)
   SELECT 
       MyCte.a,
       MyCte.b,
       MyCte.c,
       HighestNumber = (SELECT MAX(Value.Val) FROM

   … 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

   1 comment  ·  Qualify object names  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   Thanks for letting us know about this issue. It should now be fixed in the latest build of SQL Prompt (7.1.0.314)

4. Auto complete/intellisense suggestions using PIVOT

   Using PIVOT the wrong alias is suggested in the intellisense window as it is the alias from the FROM clause, not the PIVOT clause that is displayed.

   The same goes for the auto complete, where field names is (automatically) prefixed with the wrong alias (I know this feature can be disabled...)

   Ex:[code]CREATE TABLE dbo.tbTest(
   Id INT,
   foo VARCHAR(3),
   bar FLOAT
   )
   GO
   INSERT INTO dbo.tbTest
   VALUES (1, 'foo', 2)
   , (2, 'bar', 3)
   , (3, 'foo', 4)
   GO
   SELECT *
   FROM (
   SELECT *
   FROM dbo.tbTest AS tt
   ) pvt
   PIVOT (
   MAX(bar) FOR foo IN ([foo], [bar])
   )p
   [/code]
   Expanding the * gives the pvt alias, not the p alias. The same goes for the intellisense suggestions and automated prefix additions...

   Using PIVOT the wrong alias is suggested in the intellisense window as it is the alias from the FROM clause, not the PIVOT clause that is displayed.

   The same goes for the auto complete, where field names is (automatically) prefixed with the wrong alias (I know this feature can be disabled...)

   Ex:[code]CREATE TABLE dbo.tbTest(
   Id INT,
   foo VARCHAR(3),
   bar FLOAT
   )
   GO
   INSERT INTO dbo.tbTest
   VALUES (1, 'foo', 2)
   , (2, 'bar', 3)
   , (3, 'foo', 4)
   GO
   SELECT *
   FROM (
   SELECT *
   FROM dbo.tbTest AS tt
   ) pvt
   PIVOT (
   MAX(bar) FOR foo IN ([foo], [bar])
   )p
   [/code]… 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

   2 comments  ·  Qualify object names  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

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

5. qualify column names with table: temporary tables

   The qualify column names should work with temporary tables as well.

   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

   1 comment  ·  Qualify object names  ·  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/

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/