SQLSERVER中触发器的delete触发使用

CREATE TRIGGER delete_product2 ON Lt_product2_table
AFTER DELETE 
AS 
declare @productid int
declare @catalogid int
  declare xCursor CURSOR FOR  SELECT productid,catalogid   FROM deleted
  OPEN xCursor 
  FETCH NEXT FROM xCursor into @productid, @catalogid
     WHILE @@FETCH_STATUS = 0
  BEGIN
  delete from Lt_product_table where catalogid=@catalogid and productid=@productid
  FETCH NEXT FROM xCursor into @productid, @catalogid
  END
  CLOSE xCursor 
  DEALLOCATE xCursor