游标使用

 

declare @branch_id as varchar(100),@branch_desc as varchar(100)

  declare @cu_obj cursor
  set @cu_obj = cursor local scroll for

 select branch_id,branch_desc from sms_branch

  open @cu_obj
  fetch next from @cu_obj into @branch_id,@branch_desc

  while @@fetch_status = 0
  begin

    fetch next from @cu_obj into @branch_id, @branch_desc
 select @branch_id,@branch_desc
  end

  close @cu_obj