LISTING 6: Testing Modifications Against the Orders View

-- Run modifications from any of the nodes to test the triggers.
SET XACT_ABORT ON
GO

SELECT * FROM Orders

DELETE FROM Orders

SELECT * FROM Orders

INSERT INTO Orders
  SELECT * FROM Northwind.dbo.Orders

SELECT * FROM Orders

UPDATE Orders
  SET orderid = 21325 - orderid

SELECT * FROM Orders