There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  

---

How to rebuild the master database?

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,

---

Does union all remove duplicates?

0 Answers  

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---

what protocol both networks use? : Sql server database administration

0 Answers  

---

What is the difference between createstatement and preparedstatement?

0 Answers  

---

Can you leave a union at any time?

0 Answers  

---

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

---

What is a trigger?

7 Answers  

---

What is BCP? When do we use it?

2 Answers  

---