Explain the difference between delete,drop and truncate in SQL Server?

0 Answers   HCL,

---

What is nested transaction?

0 Answers  

---

Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What is view in sql?

0 Answers  

---

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

---

What happens if null values are involved in boolean operations?

0 Answers  

---

Can we write trigger for view?

0 Answers  

---

List out different types of normalizations in sql server and explain each of them?

0 Answers  

---

Explain active/passive and active/active cluster configurations?

0 Answers  

---