How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

What is linq to sql?

0 Answers  

---

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

---

How do I upgrade sql?

0 Answers  

---

What is the difference between distinct and unique in sql?

0 Answers  

---

What is on delete restrict?

0 Answers  

---

when normalization is required

3 Answers   HCL,

---

How do I filter in sql profiler?

0 Answers  

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

Can we write dml inside a function in sql server?

0 Answers  

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

What are the differences between in and exists clause?

0 Answers  

---