62 results found

1. Warnings for Execution should not warn on UPDATE/DELETE to Temporary Tables or Table Variables

   Warnings for execution should not warn on Temporary tables or table variables.
   Example:
   UPDATE T
   SET T.Description = V.Description
   FROM @Problem1099BoxRows T
   INNER JOIN APVouchers V ON T.APVoucherID = V.APVoucherID

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →

2. Suggest object by capital letter abbreviation. Similar to ReSharper

   When typing in a statement. For example:

   SELECT *
   FROM MyTable

   Instead of having to type in MyTable. I would just like to enter

   SELECT *
   FROM MT

   At which point the suggestion box would identify the table MyTable based on it's initial capital letter at the beginning of each word.

   Similar to the feature in ReSharper:

   https://www.jetbrains.com/resharper/webhelp80/Navigation_and_Search__CamelHumps.html

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Features  ·  Delete…  ·  Admin →
   completed  ·  AdminDevart (_, Devart) responded

   Please perform the following:

   1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
   2. Navigate to the ‘List Members’ branch in the ‘Options’ window.
   3. Select the ‘Camel Case’ option.
   4. Click ‘OK’.