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 |
To call a Web service SOAP which transport protocol you use?
Where do the cookie state and session state information be stored?
How to store a dataset in a viewstate?
Which object is used to encapsulate the state of the client and the browser in ASP.NET?
0 Answers Sans Pareil IT Services,
Explain the difference between inline and code behind - which is best in?
How can you handle errors in Web API?
wt is repeater control and wt is datalist control and wt defferences these two? i want some code in datalist?
What is the difference between and ActiveX dll and control ?
What Is ASPNET_WP.exe? What Is The Use Of It? In Which Place Inproc Session Stored ? Explain Session State ?
2 Answers Phoenix Technologies,
What is the need of client side and server side validation ?
What is Forms Authentication in ASP.NET?
How can you dynamically add user controls to a page?
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)