Posts
Sort by recent activity
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...
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...
[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...
7.3.0.568 - Formatting += fails
The following SQL fails to be formatted using default style:
DECLARE @txt NVARCHAR(MAX) = '';
SELECT @txt += '';
The Error dialog tells me:
Error laying out sql.
SQL PRompt was unable to complete t...