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 difference between URL and URI?
How does exception management works in ASP.NET?
what are the Custom controls in asp.net?
if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....
What is the biggest disadvantage of “Other Return Types” in Web API?
How can we use Web API with ASP.NET Web Form?
What is http protocol and how it works?
Why session is necessary in web application?
What is application session?
Can you set the session out time manually?
What is special types forms
What is the base class from which web forms are inherited?
What are the benefits of Razor View?
What is ashx file in asp.net?
What is Partial PostBack in ASP.NET?