Sql 游标处理

begin try
    begin transaction tran1;
    declare @UamAppID varchar(50),@UserID varchar(50),@visit int;
    set @UserID='test\test1';
    set @visit=10;
    declare mycursor cursor for 
     select uamappid from uamapp u where 
        not exists (select uamappid from frequentapp f where f.uamappid=u.uamappid );
    open mycursor;
    fetch next from mycursor into @UamAppID;
    while @@FETCH_STATUS=0
    begin
        print '---';
        insert frequentapp values(@UamAppID,@UserID,@visit,GETDATE(),GETDATE());
        fetch next from mycursor into @UamAppID;
    end
    commit transaction tran1;
    close mycursor;
    deallocate mycursor;
end try
begin catch
    if @@trancount>0
    begin
        close mycursor;
        deallocate mycursor;
        rollback transaction tran1;
        return;
    end
end catch