Create TRIGGER [dbo].[trigInstructionsDelete]ON dbo.Instructions instead OF DELETEAS BEGIN	DECLARE @InsId INT	SELECT @InsId=InstructionsID FROM deleted	--删除	   DELETE dbo.Transfer WHERE InstructionsID=@InsId	DELETE dbo.Instructions WHERE InstructionsID=@InsIdEND