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

How to reduce the Page size in asp.net?

4 Answers   CTS,


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?

0 Answers  


All kind of access specifiers for a class and for methods ?

1 Answers   MMTS,


How do you bind array to gridview? Will it works?

4 Answers   HP,


when the user control event occur in ASp page life cycle?

3 Answers   Microsoft,


What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?

8 Answers   Siebel Systems,


What does this do? sn -t foo.dll

3 Answers  


How to do Forms authentication in asp.net?

2 Answers  


How should I destroy my objects in asp.net?

0 Answers  


How do you define authentication in Web.Config?

2 Answers   Accenture, BirlaSoft, IBM,


Explain managed code an un-managed code.

0 Answers  


how many character send in one sms forget 160limit and think about gateway allowed

2 Answers   Wipro,


Categories