Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

To call a Web service SOAP which transport protocol you use?

3 Answers   Siebel,


Where do the cookie state and session state information be stored?

0 Answers  


How to store a dataset in a viewstate?

3 Answers   Patni,


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?

0 Answers  


How can you handle errors in Web API?

0 Answers  


wt is repeater control and wt is datalist control and wt defferences these two? i want some code in datalist?

1 Answers  


What is the difference between and ActiveX dll and control ?

1 Answers   Microsoft,


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 ?

1 Answers   Keane India Ltd,


What is Forms Authentication in ASP.NET?

0 Answers  


How can you dynamically add user controls to a page?

0 Answers  


Categories