Activity overview
Latest activity by sfrigard
I have attached my style that I am currently setting up. In addition I have attached a sanitized SQL script with my target formatting. / comments
I have attached my style that I am currently setting up. In addition I have attached a sanitized SQL script with my target formatting.
How can I stop OPENJSON after CROSS APPLY from showing up on new line
SELECT * FROM OPENJSON(@..., '$.Doc') AS OJ CROSS APPLY OPENJSON(OJ.Value) WITH (ID int) AS CAOJbecomesSELECT * FROM OPENJSON(@..., '$.Doc') AS OJ CROSS APPLY OPEN...
Code Analysis:DataType Mismatch Detection
I was wondering if Code Analysis is capable to detecting implicit conversion issues.I have inherited a database where a lot of the stored procedures have various types of data type mismatch issue r...
SQL Prompt 8.1.0.2354
I have set up the formatting style to match our standards. One issue I have is that for the Data (DML) the handling of SELECT ... INTO is not handled correctly. See example:
Smart Rename not handling Schema Moves properly
I am moving a large number of objects from one schema to another. I notice that when there are programmability objects involved in the refactoring, that the Alter Schema statement is called after t...