TSQL Cursor Syntext

declare cursor cust_cursor fast_forward for
select custid from tblCustomer
Open cust_cursor
fetch next from cust_cursor into @custId
while @@fetch_status = 0
begin
fetch next from cust_cursor into @custId
end
close cust_cursor
deallocate cust_cursor

Advertisements