Simple Cursor Example

Rajesh_Kumar
Posted by Rajesh_Kumar under Sql Server category on | Points: 40 | Views : 537
declare project_cur cursor for
select project_name from project_master where project_name is Not null;
open project_cur
fetch next from project_cur
while @@fetch_status = 0
begin
fetch next from project_cur
end
close project_cur
deallocate project_cur

Comments or Responses

Login to post response