Explain triggers in sql?

0 Answers  

---

Tell me what is log shipping?

0 Answers  

---

What are the essential components of sql server service broker?

0 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

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 m-m relationships are implemented?

2 Answers  

---

Do you know how to send email from database?

0 Answers  

---

When a primary key constraint is included in a table, what other constraints does this imply?

0 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

Differentiate between a local and a global temporary table?

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---