🚧 UPDATE with JOIN & OUTPUT
🚧 Coming soon: Update via join and log affected rows using OUTPUT inserted.*, deleted.*.
-- Placeholder
UPDATE p
SET p.Price = p.Price * 1.05
FROM dbo.Products p
JOIN dbo.Categories c ON c.CategoryID = p.CategoryID;
🚧 Coming soon: Update via join and log affected rows using OUTPUT inserted.*, deleted.*.
-- Placeholder
UPDATE p
SET p.Price = p.Price * 1.05
FROM dbo.Products p
JOIN dbo.Categories c ON c.CategoryID = p.CategoryID;