CREATE TABLE [dbo].[orderlinks] (
	[OrderID] [int] NOT NULL ,
	[SoprID] [int] NOT NULL ,
	[Amount] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[orders] (
	[OrderID] [int] NOT NULL ,
	[Giv] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[orderlinks] WITH NOCHECK ADD 
	CONSTRAINT [PK_orderlinks] PRIMARY KEY  CLUSTERED 
	(
		[OrderID],
		[SoprID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[orders] WITH NOCHECK ADD 
	CONSTRAINT [PK_orders] PRIMARY KEY  CLUSTERED 
	(
		[OrderID]
	)  ON [PRIMARY] 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE VIEW dbo.OLnk WITH VIEW_METADATA
AS
SELECT     dbo.OrderLinks.*, dbo.Orders.giv
FROM         dbo.OrderLinks INNER JOIN
                      dbo.Orders ON dbo.OrderLinks.OrderID = dbo.Orders.OrderID

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE TRIGGER [OLnk_Del] ON [dbo].[OLnk]
INSTEAD OF DELETE
AS
BEGIN
UPDATE o SET o.giv=o.giv-d.amount FROM Orders o
INNER JOIN (SELECT Deleted.OrderID, SUM(Deleted.Amount) AS Amount FROM Deleted
GROUP BY Deleted.OrderID) d ON o.OrderID = d.OrderID
DELETE lnk FROM OrderLinks lnk INNER JOIN Deleted d ON lnk.OrderID = d.OrderID AND lnk.SoprID = d.SoprID
END

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

insert into orders select  1 , 10  union select  2 , 0 
insert into orderlinks select  1 , 4 , 5  union select  1 , 8 , 5 

delete from dbo.OLnk where orderid= 1 

select * from orders
select * from orderlinks

OrderID     Giv         
 ----------- ----------- 
 
 1             0 
 2             0 

( 2  row(s) affected)

OrderID     SoprID      Amount      
 ----------- ----------- ----------- 
 

( 0  row(s) affected)