How to query multiple tables jointly?

0 Answers  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

Explain DBCC?

0 Answers   QuestPond,

---

What does Master database contains?

0 Answers   Abacus,

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

---

What is an sql server agent?

0 Answers  

---

Can we write ddl in trigger?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

How do you start single user mode in clustered installations?

0 Answers  

---

What are the types of resultset?

0 Answers  

---

What are a scheduled jobs?

0 Answers  

---

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

---