Kevin Suchlicki questions

Kevin Suchlicki answers

• SQL Server - Cascading DELETE with Recursive Foreign Keys
• Force a Transaction to commit from another connection?
• SQL SELECT If (a="") Then change b value
• Hierarchical SQL data (Recursive CTE vs HierarchyID vs closure table)
• How to use ROW_NUMBER() in UPDATE clause? [duplicate]
• Querying XML Rows For New Non-XML Rows