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

About Jignesh

hi there, I am software engineer, working in e-commerce company and passionate about all thing digital. On this blog, I share my experiments with different technology.

‹ Table compression in SQL Server

Create and apply Patch in git ›

Tagged with: Cursor, tsql
Posted in SQL Server