cursor in sql

–Declare Cursor

Declare  FetchEmpCodeonebyone
cursor for
select EmpCode from empmaster
Declare @EmpCode nvarchar(20)
open FetchEmpCodeonebyone
Fetch Next from FetchEmpCodeonebyone into @EmpCode
while (@@Fetch_status = 0)
begin
--your logic start
select @EmpCode
-- your logic end
Fetch Next from FetchEmpCodeonebyone into @EmpCode
end
--Close and Deallocate Cursor
Close FetchEmpCodeonebyone
Deallocate FetchEmpCodeonebyone
Advertisements
This entry was posted in Sql. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s