I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---

Explain sql server authentication modes?

0 Answers  

---

Can you explain different types of joins?

0 Answers  

---

What is the process of normalization?

0 Answers  

---

Define the term DML, DDL and DTL?

1 Answers  

---

How to create a ddl trigger using "create trigger" statements?

0 Answers  

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

How many types of Outer Joins?What are they?

1 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---