2 results found

1. Autofix with shortcut

   A shortcut to implement the autofix changes.
   Would be nice if it wasn't necessary to use the mouse when applying autofixes.

   It is almost there; you can press ctrl and get the error window and even just press enter then, to apply the fix. But the window stays and there is no reason to actually open the window, the fix could/should just be applied

   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  ·  Code Analysis  ·  Delete…  ·  Admin →
   completed  ·  AdminAndrea Angella (Admin, Redgate) responded

   We added the ability to autofix issues using the Alt + Enter keyboard shortcut in SQL Prompt 10.1.

2. A Create/Declare Table statement with a Primary Key gives a false positive BP014 in Code Analysis

   If you have a table declared like this:
   Declare @Test table
   (TheKey int Primary Key,
   SomeData varchar(10) Not Null)

   I am told that for "TheKey" "[NOT] NULL option is not specified in CREATE/DECLARE TABLE statement" defined. But, a Primary Key can never be null, so it is NOT NULL by nature.

   So, when performing Code Analysis and the parser sees "Primary Key", "Not Null" should be inferred also.

   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  ·  Code Analysis  ·  Delete…  ·  Admin →
   completed  ·  Thomas Walsh responded

   Hi,

   I’m pleased to announce this issue was fixed in version 9.4.10 of SQL Prompt. You can access the latest version from https://www.red-gate.com/products/sql-development/sql-prompt/

   Thank you for bringing it to our attention!

   Kind Regards,
   The Prompt Team