SQL TRIGGER

CREATE TRIGGER return_lost_wrnt_lock           
   ON  RETURN_HDR_DTL           
   FOR  INSERT           
AS              
BEGIN             
 SET NOCOUNT ON             
 IF  EXISTS (SELECT '*' FROM INSERTED       
       WHERE lost = 1   
         AND warranty = 1)
              
 BEGIN  
          
 RAISERROR('PLEASE SELECT EITHER LOST OR WARRANTY ELSE NONE',16,2)             
 ROLLBACK TRAN
 END                 
END  

-- DROP TRIGGER RETURN_LOST_WRNT_LOCK