How to test a dml trigger in ms sql server?

0 Answers  

---

What are various limitations of the views?

0 Answers  

---

What is the difference between constraints and triggers?

9 Answers   Wipro,

---

What is a function? Give some example?

3 Answers  

---

What is attribute? : sql server analysis services, ssas

0 Answers  

---

Which stored procedure will you be running to add a linked server?

1 Answers  

---

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

---

What are points to remember while using the fillfactor argument?

0 Answers  

---

What is the difference between for trigger and after trigger?

0 Answers  

---

What are a scheduled jobs or what is a scheduled tasks?

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 to delete exactly duplicate records from a table?

0 Answers  

---