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
What is asp.net file?
3. What goals do you have in your career?
What is the file through which you can customize your asp.net application?
what is the difference between response.write() and response.output.write()?
How do you do Client-side validation in .Net?
Which method is used to force all the validation controls to run?
Difference between using directive vs using statement?
Describe the application event handlers in ASP.NET?
Where the cookie value is stored?
Differentiate between namespace and assembly.
What is asp.net caching?
What is strong-typing versus weak-typing?
What is viewstate? What does the "enableviewstate” property do? Whay would I want it on or off?
What is the purpose of master page?
Write code to send e-mail from an asp.net application?