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 cookie less session? How it works?

2 Answers   TCS,


# What is the transport protocol you use to call a Web service?

1 Answers  


To display data in the combo box, prior to setting the Data Source, what kind of property on a Combo Box do you set with a column name?

0 Answers   Siebel,


Can two web application share a session and application variable ?

5 Answers   Satyam, V3 Engineers,


How do you implement Paging in .Net ?

1 Answers  






Explain how does asp page work?

0 Answers  


What is State Management in .Net and how many ways are there to maintain a state in .Net?

6 Answers  


Where is session data stored in asp net?

0 Answers  


What is session and application variable in asp net?

0 Answers  


What is the use of HttpHandlers? When to use this?

0 Answers   Wipro,


Does JITting occur per-assembly or per-method? How does this affect the working set?

1 Answers  


What is the use of service provider?

0 Answers  


Categories