Search
-
I can´t install the latest version of SQL Search
-
SQLServer2022 - IS [NOT] DISTINCT FROM breaks intellisense
-
Re: Comparing databases - Failed
-
No column suggestion for CTE with row value constructor
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… -
Re: How do I uninstall and reinstall SQL Search 3 when it's not in my programs?
-
Formatting bug when using windowed functions
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 =… -
SELECT alias capitalization issue.
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… -
SQLDataCompare API examples - Composite Formatting ?
-
Re: Automate Restore of Databae Backups - Full and Log - Backup pro 10
There will need to be 2 jobs. For the hourly log backups, look into the RESTORE LOG command in SQL Backup. It allows you to specify a search pattern for the transaction log backup files, which it will then restore automatically for you in sequential order, then move the files to a different folder so that it will not be…
>1648 results