What is difference between stored procedure and function?

3 Answers   L&T,

---

What is lookup override?

0 Answers   Informatica,

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

---

What do you understand by triggers?

0 Answers  

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

How do you Implement SSIS Packages in your Project?

0 Answers  

---

How to delete duplicate rows?

0 Answers  

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

0 Answers  

---

How to apply cascading referential integrity in place of triggers?

0 Answers  

---

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

---