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 |
Which is an advantage of application service providers?
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?
what is the use of asp.net
What is X-Path?
Suppose You Want A Certain Asp.net Function Executed On Mouseover For A Certain Button. Where Do You Add An Event Handler?
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
What are different ASP.NET Web Forms with the technology different from though ASP (1.0-3.0)?
Interface and Abstract class, inheritance, abstraction with examples. Polymorphism (difference betn overloading and overriding
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?
Can you explain one critical mapping? Performance issue which one is better? Whether connected lookup tranformation or unconnected one?
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