Rollback & Return

السلام عليكم

ماهو الفرق بين استخدام كلمه

Rollback & Return

عند عمل Trigger

مثال

--------

alter trigger eee
on rrr
instead of insert
as begin
declare @no int
select @no = jobid from job j join inserted  i on j.[job name] = i.[job name]
if (@no is null )
       begin
       print 'sorry I Cant'
       return
       end
    
insert into emp (firstname ,city ,jobid)select  firstname,city,@no from inserted
end

----------------------------------------

alter trigger tr_stop
on emp
after delete
as begin
         if exists (select 1 from deleted  as i where (len (i.firstname )> = 5 ) and i.jobid  is null)
         begin
         print 'Sorry I Cant Name Over Than 5 Char And Job Is Null'
         rollback
         end
end