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  

---

What is the difference between rank and dense_rank?

0 Answers  

---

What are relationships and mention different types of relationships in the dbms

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

0 Answers  

---

Explain data warehousing in sql server?

0 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

0 Answers  

---

What happens to a statement batch if there is a compilation error?

0 Answers  

---

What is difference between equi join and natural join?

0 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

Explain what is it unwise to create wide clustered index keys?

0 Answers  

---