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 |
What is cookie less session? How it works?
# What is the transport protocol you use to call a Web service?
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?
Can two web application share a session and application variable ?
5 Answers Satyam, V3 Engineers,
How do you implement Paging in .Net ?
Explain how does asp page work?
What is State Management in .Net and how many ways are there to maintain a state in .Net?
Where is session data stored in asp net?
What is session and application variable in asp net?
What is the use of HttpHandlers? When to use this?
Does JITting occur per-assembly or per-method? How does this affect the working set?
What is the use of service provider?