Interested to Buy Any Domain ? << Click Here >> for more details...
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 the difference between a cookie and a pixel?
Explain diff. Between friend and protected friend?
What is cross page posting? How is it done?
What are the differences between code behind and code inline?
Explain the difference between response.redirect vs server.transfer
What is view state management in asp net?
What is asp net objects?
What is recordset asp?
Explain the difference between codebehind="mycode.aspx.cs" and src="mycode.aspx.cs"?
What is difference between or and orelse?
Which is better session or viewstate?
Is session server side or client side?
What is inheritance and an how it be used, example with an example?
How many types of cookies are there in asp.net?
If you have an application with multiple security levels though secure login and my ASP.NET web appplication is spanned across three web-servers by using round-robbin load balancing. Explain which is the best approach to maintain login-in state for the users?
