Finding Equal Row Sets Across Different Tables in SQL Server Using the FOR XML Trick or Alternative Approaches

Automating Unique Auto-Increment Values in SQL Server Using Stored Procedures, Table-Valued Functions, and Common Table Expressions