cursor,transaction

cursor:

1. DECLARE MyCURSOR1 CURSOR [local|globbal]  FOR
    select ItemCD, ReasonDiv,ReasonCon,ReasonVal from SPS_ItemMaster
2. open MyCURSOR1
3. while i<@@cursor_rows
4. fetch next from  MyCURSOR1 into @ItemCD,@ResName,@ResCon,@ResVal
5. fetch first|prior|last|relative -2 from MyCURSOR1
6. close MyCURSOR1
7. deallocate MyCURSOR1

transaction:

begin transaction

insert into|update|delete....

save tran Mytranname

insert|update|delete

Rollback tran Mytranname

commit tran

go

 

2.

declare @tran_name varchar(20)

set @tran_name ='aa'

begin transaction @tran_name

go

insert into|update|delete....

 

go

commit transaction @tran_name