Posts
Sort by recent activity
"Add quotes and commas" Bug - Changes Ctrl-End/End Behaviour
Hi,Ctrl-End usually puts the cursor to the end of the SSMS document, but if pressed too soon after using "Add quotes and commas" (i.e. before the formatting has been applied) it will instead take y...
Error parsing valid SQL
I tried to send this via error report in SQL Source Control but it's timing out:
"There was an error parsing the file "...\dbo.fn_SpidFilter.sql" at line 7, column 40 near the text ."
This prevents...
Action List Won't Disappear - SSMS
I've got a stubborn action list that won't disappear despite my best efforts!
Unfortunately I'm unsure what caused it, as to help you reproduce the error, but I'm left with an action list stuck on ...
Window Functions and Group By Auto-fill
Hi,
I've just seen that Window functions can be incorrectly populated in the 'group by' portion of a SQL statement when the partition portion of the function is populated.
For instance the followin...
Issue running current query in Alter Table statement
SQL Prompt doesn't seem to like the following statement:
ALTER TABLE x.y
ADD StartTime DATETIME2 GENERATED ALWAYS AS ROW START
HIDDEN DEFAULT GETUTCDATE(),
EndTime DATETIME2 GENERATED ALWAYS AS RO...