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

What is the difference between union and join?

0 Answers  

---

What is strong-typing versus weak-typing?

0 Answers  

---

What is the mvc framework?

0 Answers  

---

What is asynchronous call?

0 Answers  

---

When would you not use the oleDbConnection object? a) To connect to an SQL 7.0 database. b) To connect to a DB/2 database. c) To connect to an Access database. d) To connect to an SQL 6.5 database.

6 Answers   Syntax Softtech,

---

---

what are debugging types in .net?

2 Answers   ABC, NIIT,

---

Tell About Global.asax ?

3 Answers   Keane India Ltd,

---

What are the differences between Trace and Debug?

2 Answers   Accenture,

---

How do we implement bundling in MVC?

0 Answers   B-Ways TecnoSoft,

---

What is a reflection?

0 Answers  

---

Difference between datagrid and datareader?

1 Answers  

---

What do you understand by aggregate dependency?

0 Answers   MindCracker,

---