DB Skills -- Autocommit

Sybase:

 

1. Links

 

2. A way to avoid autocommit without setting optoin "chained'

declare cursor_o cursor for
select distinct yld_id from tempdb..yield_list
go

open cursor_o
declare @yld_id int, @deleteStatus int, @insertStatus int

fetch cursor_o into @yld_id
while @@sqlstatus = 0
begin
    begin transaction
    delete from yield_list where yld_id = @yld_id
    select @deleteStatus = @@error
    insert into yield_list select * from tempdb..yield_list where yld_id = @yld_id
    select @insertStatus = @@error
    if (@deleteStatus = 0 and @insertStatus = 0)   
        commit transaction    
    else
        rollback transaction
    fetch cursor_o into @yld_id   
end
close cursor_o

DEALLOCATE CURSOR cursor_o
go

 

MS SqlServer

d