what is the cursor



what is the cursor..

Answer / 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

More ASP.NET Interview Questions

Which is an advantage of application service providers?

0 Answers  


In your ASP.NET 2.0 web application you want to display an image that is selected from a collection of images. What approach will you use to implementing this?

0 Answers   HCL,


what is the use of asp.net

3 Answers   ABC,


What is X-Path?

2 Answers   Sherston,


Suppose You Want A Certain Asp.net Function Executed On Mouseover For A Certain Button. Where Do You Add An Event Handler?

0 Answers   Siebel Systems,






On what object is the transaction in ADO.NET focused on? a) The command object b) The DataSet object c) The Connection object d) The DataAdapter object

4 Answers   Syntax Softtech,


What are different ASP.NET Web Forms with the technology different from though ASP (1.0-3.0)?

1 Answers   Siebel,


Interface and Abstract class, inheritance, abstraction with examples. Polymorphism (difference betn overloading and overriding

2 Answers   Syntel,


Which property needs to be set for script manager control to extend the time before throwing time out expection if no response is received from the server?

0 Answers  


Can you explain one critical mapping? Performance issue which one is better? Whether connected lookup tranformation or unconnected one?

0 Answers  


What is view state and how this can be done and was this there in asp?

11 Answers   Accenture, KDOT, Mphasis,


What is Difference between Application object and Session Object

5 Answers  


Categories