Answer Posted / om shivaya namaha
Cursors are used to fetch the records row by row data in a
table but get the data very fast by using the cursors it is
very useful if the table contains few records in a table but
will create a performance isses if the table contain lot of
records
create cursor cursorName for
select EmpId,EmName from Employees
open cursor
while (@@FetchStatus==0)
begin
fetch next from cursorName into @EmpId , @EmName
select * from Employee where empid=@empid
end
close cursor
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Classic ASP and ASP.Net?
Can the validation occurs in server-side or client-side? If the validation occurs why should we do?
What is asp.net globalization?
Which method do you use to kill explicitly a users session?
What is the application pool?
Is it true that a Web service must be written in .NET or not?
What is advantage of code behind coding in ASP.NET?
What are themes and skins in 2.0, explain usage scenario?
What are the steps involved to fill a dataset?
What is the use of session?
What is boxing and unboxing in asp.net?
What is a 1x1 pixel?
What is httpresponse?
How can we update records in gridview?Is there any appropriate code for it?
Which dll handles the request of .aspx page?