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   HCL,

---

When we should use and scope of @@identity?

0 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

Define synonym?

0 Answers  

---

How to tune a stored procedure?

6 Answers  

---

How do you size a resultset?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

Can I delete event logs?

0 Answers  

---

How to create a Master database in SQL server ?

0 Answers   MCN Solutions,

---

Difference between connected and disconnected database in .net with sql server?

0 Answers   Infosys,

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---

please differentiate between delete and truncate?

0 Answers  

---