TR_BILLINGITEM_INSERT_UPDATE (Trigger)

                
          create trigger TR_BILLINGITEM_INSERT_UPDATE on dbo.BILLINGITEM after insert,update not for replication
          as begin
              begin try
                if (exists (select PRODUCT.ID
                from INSERTED I inner join dbo.PRODUCT on I.NAME=PRODUCT.NAME
                 where (PRODUCT.ID <>I.ID )))
                      begin
                        raiserror('ERR_BILLINGITEM_NAMEISUNIQUE', 13, 1);
                      end
              end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                end catch
          end