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

how can we maintain security in soted procedure?

1 Answers  

---

Is a dll file an executable?

0 Answers  

---

Can u able to get the xml document in crystal report if yes how its possible

2 Answers  

---

What is the use Membership in asp.net? and What is the use profiler in asp.net?

1 Answers  

---

Web API uses which library for JSON serialization?

0 Answers  

---

Why would a company use an application service provider?

0 Answers  

---

What is asp.net futures?

0 Answers  

---

what is difference between User Control,Custom Contro1,Web server control and template controls

1 Answers  

---

What is Model-View-View Model?

0 Answers   MCN Solutions,

---

What are the different methods of session maintenance in asp.net?

0 Answers  

---

What is view state and how it works in asp net?

0 Answers  

---

what are partial classes and their use?

1 Answers   Patni,

---