what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

---

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

How to drop an existing table with "drop table" statements in ms sql server?

0 Answers  

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

---

What is optimization and its types?

0 Answers  

---

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---

What do you mean by normalisation?

0 Answers  

---

explain the storage models of olap? : Sql server database administration

0 Answers  

---

Explain SELF JOIN ?

3 Answers   ADP,

---

wht's the differece between sqlserver05 and sqlserver2000

3 Answers  

---

What is a with(nolock)?

0 Answers  

---