lptr questions

lptr answers

• DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause
• How to monitor table structure changes in SQL Server?
• SQL Server For JSON Path dynamic column name
• Is it possible to combine columns from a view and a stored procedure?
• How to generate json data with group by in SQL
• Data Sync between tables from SQL Server & Db2 - how to delete rows
• How to implement constraint based referential integrity on a simple 3 way relation
• SQL Server geography testing if a point is within a bounds - what does STWithin() do?
• Unexpected @@rowcount behavior inside an UDF in MS SQL 2019
• Convert UTF-8 varbinary(max) to varchar(max)