Activity overview
Latest activity by henrik_ffc
Seems this comment is enough to create the error: (one star + one empty line) /* * */ / comments
Seems this comment is enough to create the error: (one star + one empty line)/***/
Code Analysis VS "IS DISTINCT FROM"
using "IS DISTINCT FROM" in a proc, disables code analysis :-(Where is the green underline under @unused in proc test2 / line #17?SSMS 20.2 / SQL Prompt 10.14.21.9884 / Default Code analysis rules...
Matthew_Chappelow said:
You are correct. A fix for this should be out with the next release
Just installed V3.2.1.2206 and the positioning of the results works WAY better now. Thank you! / comments
Matthew_Chappelow said:
You are correct. A fix for this should be out with the next release
Just installed V3.2.1.2206 and the positioning of the results works WAY better now.Thank you!
The problem still exists in version 3.2.0.2180. / SSMS 17.9. After scrolling down the first result, the second result tries to open at the exact same scroll-position as first result. If result 1 is a very long procedure and I scroll to the bottom and change to result 2, it now tries to position the result-pane below EOF, resulting in at empty result (until I scroll up) / comments
The problem still exists in version 3.2.0.2180. / SSMS 17.9.After scrolling down the first result, the second result tries to open at the exact same scroll-position as first result.If result 1 is a...
AT TIME ZONE not working?
Creating a table like this:CREATE TABLE TimezoneTest( utctime DATETIME2(2) NOT NULL
, starttime AS CAST(utctime AT TIME ZONE 'UTC' AT TIME ZONE 'W. Europe Standard Time' AS DATETIME2(2)));
Works...
"WITHIN GROUP" order clause is not supported for STRING_AGG aggregate
SQL Prompt reports an error when I try to format a statement including STRING_AGG with the optional WITHIN GROUP order clause
(https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transa...
BTW: The affected databases are stuck at "Checking schema..."-state on the DLM dashboard / comments
BTW: The affected databases are stuck at "Checking schema..."-state on the DLM dashboard
[Error] Failed while taking a snapshot.
Hi,
I am getting a "A duplicate object name has been found"-error. Perhaps because the database is case sensitive, so how do I switch on the "case sensitive option"?
The affected databases are stuc...
Bug: Error when formatting "alias = " as "AS alias"
When I try to format the following valid SQL with no space before "FROM":
SELECT principal_id =ISNULL(principal_id,0)FROM sys.objects
SQL prompt fails after converting the SQL into this invalid SQL...
Did not work in 7.3.0.583, but DID work in 7.3.0.585.
Thanks!
// Henrik / comments
Did not work in 7.3.0.583, but DID work in 7.3.0.585.
Thanks!
// Henrik