How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

What is the difference between constraints and triggers?

9 Answers   Wipro,

---

What is difference between group by and having?

0 Answers  

---

Explain about remote stored procedure?

0 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

How to name query output columns in ms sql server?

0 Answers  

---

Explain the properties of a relational table?

0 Answers  

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---

How to invoke a trigger on demand?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---