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
Explain about Multi-Language integration?
What is the significance of ASP.NET routing?
What is the default authentication mode for asp.net?
What is asp.net version?
Differentiate the session object and application object?
What is microsoft windows sharepoint services?
Can you dynamically assign a Master Page?
What is css in asp.net?
Explain some of the major built-in objects in asp.net
I want to connect a system in LAN and I want to access that. Whenever I am moving a mouse in my desktop, the similar thing has to happen in another system in which I have connected. I need coding for this in C# and ASP.NET Can anyone please help me. It is very urgent. Thanks in advance. My email id is manojkumarchallagundla@gmail.com Will you please?
What is active web page?
What is the difference between union and join?
What is difference between inproc and outproc?
What is master page in dtp?
In which situation can you not use a viewstate?
