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
How tooltip is set through code-behind in ASP.NET?
What does asp.net stand for?
what cut off mark for po's,what questions they asked for interview?
What are the event handlers that we can have in global.asax file?
What is the mvc framework?
In order to get assembly info which namespace we should import?
Can you explain one critical mapping? Performance issue which one is better? Whether connected lookup tranformation or unconnected one?
How do you deploy your asp.net application?
What is the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc
In the Repeater control which way you can edit?
What is Bundling and Minification in MVC?
What are the uses of list view control in Asp.net?
What is difference between cookies and cache?
How to implement Authentication and Authorization?
What is difference between asp state management and asp.net state management?