MERGE Statements - SQL Server to Snowflake Translation Series After 20 years with SQL Server, MERGE statements are a love-hate relationship. They're powerful. They're also a prime source of blocking ...
SET IDENTITY_INSERT dbo.Orders ON; MERGE INTO dbo.Orders AS T USING ( VALUES (10248, 90, 5, '1996-07-04', 3), (10249, 81, 6, '1996-07-05', 1) ) AS S (OrderID, CustID ...