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 |
How to reduce the Page size in asp.net?
Let's say I have an existing application written using vb6 and this application utilizes windows 2000 com+ transaction services. How would you approach migrating this application to.net?
All kind of access specifiers for a class and for methods ?
How do you bind array to gridview? Will it works?
when the user control event occur in ASp page life cycle?
What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?
What does this do? sn -t foo.dll
How to do Forms authentication in asp.net?
How should I destroy my objects in asp.net?
How do you define authentication in Web.Config?
2 Answers Accenture, BirlaSoft, IBM,
Explain managed code an un-managed code.
how many character send in one sms forget 160limit and think about gateway allowed
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)