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 |
What are the advantages of the code-behind feature?
Explain Factory pattern?
How to turn off cookies for a page?
Page Life Cycle in ASP.NET
Is string a value type or a reference type?
What are ASP.NET Web Forms? How is this technology different than what is available though ASP (1.0-3.0)?
Explain State management in asp.net
How may clustered index we can create in table?
How do you do exception management
What do you mean by authorization?
What is the difference between exe and dll?
Explain the main function of url routing system in asp.net mvc? : asp.net mvc
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)