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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between Classic ASP and ASP.Net?

1106


Can the validation occurs in server-side or client-side? If the validation occurs why should we do?

1045


What is asp.net globalization?

980


Which method do you use to kill explicitly a users session?

1063


What is the application pool?

960


Is it true that a Web service must be written in .NET or not?

1097


What is advantage of code behind coding in ASP.NET?

1030


What are themes and skins in 2.0, explain usage scenario?

940


What are the steps involved to fill a dataset?

1026


What is the use of session?

936


What is boxing and unboxing in asp.net?

1071


What is a 1x1 pixel?

952


What is httpresponse?

961


How can we update records in gridview?Is there any appropriate code for it?

2168


Which dll handles the request of .aspx page?

968