CREATE TRIGGER trg_ForUpdateOnBookIssuedDetails
ON BOOKISSUEDDETAILS
FOR UPDATE
AS begin
declare @Rows1 int,@Rows2 int
IF(UPDATE(ReturnedOn))
 
begin
begin tran
UPDATE nur
SET nur.NumberOfBooksIssued = nur.NumberOfBooksIssued -1
FROM NewUserRegister nur INNER JOIN INSERTED i
ON i.IssuedTo=nur.UserName
 
SET @Rows1 = @@RowCount
 
UPDATE lbd SET Inventory = Inventory +1
FROM LIBRARYBOOKDETAILS lbd INNER JOIN
inserted i ON lbd.BookID = i.BookId
 
SET @Rows2 = @@rowcount
 
IF @Rows1 * @rows2 >0
commit tran
else
begin
raiserror('Error Updating the Database',16,-1)
rollback tran
end
end
end