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

What is difference between or and orelse?

0 Answers  


How do you register the .Net Component or Assembly?

2 Answers   Accenture,


Turn Off ASP Session State on an IIS 5.1 Web Site

1 Answers  


How to unit test Web API?

0 Answers  


view state data is stored in which format?

15 Answers   Mind Tree, Pratham Software,


Types of authentications in ASP.NET ?

9 Answers   Accenture, Roland, Shriram,


Do you support digital rights management to protect my videos?

0 Answers  


I am having four text boxes in my web application. I am setting Required Field validator to each Text box. And I am having two buttons in my application. If i clicked the first button only first two text box validation will get fire. Dont show error message for remaining two text box. If i clicked second button last two text box validation will get fired. It will not consider the first two validation controls. That is how to enable and disable the validation controls.

4 Answers  


What is client side state management?

0 Answers  


Master Page

1 Answers   Syntel,


Can I stream live content/events?

0 Answers  


What ports must be open for DCOM over a firewall? What is the purpose of Port 135?

0 Answers  


Categories