sql Cursor

In sql Cursor gives you ability to deal in rows


--CURSOR.....
declare cr_markaListesi CURSOR FOR
select markaKod,marka
from tblMarka

open cr_markaListesi
declare @markaKod int, @marka varchar(55)

fetch cr_markaListesi into @markakod,@marka

while(@@Fetch_Status=0)
begin
fetch cr_markaListesi into @markakod,@marka
print cast(@markakod as varchar(33))
print @marka
--sonraki kayıt
fetch cr_markaListesi into @markakod,@marka
end

--cursor kapat
close cr_markaListesi
--memoryi boşalt
deallocate cr_markaListesi