What is exclusive locks?

0 Answers  

---

What are the difference between primary key and unique key? : sql server database administration

0 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

---

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

Different Types of Functions ?

2 Answers   Satyam,

---

What is the Difference beween sql server 2005 and sql server 2008

3 Answers   CMC, Hitech,

---

Explain transaction server distributed transaction?

0 Answers  

---

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---