declare cur_mycursor cursor for select columnA,columnB,columnC from mytalbe open cur_mycursor fetch next from cur_mycursor into @columnA_value,@columnB_value,@columnC_value while @@fetch_status=0 begin print @columnA_value print @columnB_value print @columnC_value fetch next from cur_mycursor into @columnA_value,@columnB_value,@columnC_value end