Search

1. SQLServer2022 - IS [NOT] DISTINCT FROM breaks intellisense

   

   Question by ehv · April 11, 2024 5:40PM · Home› SQL Server Products› SQL Prompt

   Seems like Prompt/Intellisense breaks when using the new IS [NOT] DISTINCT FROM predicate feature that came with SQLServer2022 https://learn.microsoft.com/en-us/sql/t-sql/queries/is-distinct-from-transact-sql?view=sql-server-ver16 

2. Re: Comparing databases - Failed

   

   Comment by Sallesg · January 26, 2024 3:46PM · Home› SQL Server Products› SQL Compare

   Ooops. I haven`t noticed that. That did work. Thanks for pointing me out. 

3. Flyway command line FIPS enable & compliant chagnes

   

   Question by chagan445 · April 12, 2024 10:39AM · Home› Database DevOps› Flyway (General Discussion)

   Was going through the Flyway Command line Github & Document however didn;t found any configuration related to FIPS changes Could someone please point to wiki if any available or share command line. GitHub - https://github.com/flyway/flyway it would be also fine to build it, if instruction provided with patch of code…

4. Re: Compare 10.2 and localDB in MSSQL2012

   

   Comment by isannn · August 16, 2012 2:22AM · Home› Discontinued and Previous Versions› SQL Compare Previous Versions

   http://screencast.com/t/WZq6jMEvYeTM http://screencast.com/t/pbPSJiVGr

5. No column suggestion for CTE with row value constructor

   

   Discussion by jamieuka · January 3, 2012 4:32AM · Home› Discontinued and Previous Versions› SQL Prompt Previous Versions

   Example using SQL Server 2008 supported Standard SQL syntax: WITH T AS (SELECT * FROM (VALUES (1)) AS T (c)) SELECT * FROM T WHERE T ...then type a dot and I would expect the first suggestion to be the column name `c` but it is not shown as a suggestion at all. Out of interest, it does appear when using this equivalent…

6. Recovery Pending not fixed by Restarting SqlClone Agent

   

   Question by kevin_patterson · October 12, 2023 2:02PM · Home› SQL Server Products› SQL Clone

   We have two clones remaining in "Recovery Pending" after a system reboot. According to SQL Cloned DB goes into recovery state after reboot. — Redgate forums (red-gate.com), this would be fixed by restarting the SQL Clone Agent service on the server. Doesn't make a difference. The Clone Dashboard no longer reports this…

7. Re: Refresh suggestions

   

   Comment by torsten.strauss · January 12, 2018 9:37AM · Home› SQL Server Products› SQL Prompt

   Hi Krzysztof! Maybe I am wrong but the logic considering your approach should be: CREATE TABLE t(col1 int) -- correct suggestion although the table is not created SELECT * FROM t DROP TABLE t; -- after dropping the table logically (in the script but no execution) or physically the -- table t should not be listed in the…

8. SELECT alias capitalization issue.

   

   Discussion by njahncke · December 3, 2009 9:35AM · Home› Discontinued and Previous Versions› SQL Prompt Previous Versions

   SQL PROMPT VERSION: v4.0.3.12 SSMS VERSION: v10.0.2531.0 OS VERSION: Windows 7 Enterprise x86 PROBLEM: Aliases in the SELECT portion of a statement are not capitalized appropriately. Capitalization of aliases in the WHERE and other portions of a statement is performed as expected. STEPS TO REPRODUCE: Note: The following…

9. Formatting bug when using windowed functions

   

   Discussion by eugenen · November 12, 2013 6:22AM · Home› SQL Server Products› SQL Prompt

   I would not expect the t.* or the tables to be aligned/placed where they are. If you comment the first line i.e the sum then it formats properlyselect sum(t.Amount) over (), t.*from payment.Applications as a inner join payment.Transactions as t on t.ApplicationId = a.ApplicationIdwhere a.ExternalId =…