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  

---

Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

---

What are the two types of concurrency?

4 Answers  

---

What to check if a User database is locked?

0 Answers   TCS,

---

Can we shrink data file in sql server?

0 Answers  

---

How to create new databases with "create database" statements?

0 Answers  

---

can primery key be a non clustered index?

10 Answers  

---

user defined datatypes

1 Answers   Wipro,

---

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---

What are the types of table?

0 Answers  

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---