What is difference between inner join and join?

0 Answers  

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

Write a sql query to display the current date?

0 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---

How to recreate an existing index in ms sql server?

0 Answers  

---

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---

Explain about protocol layer present in SQL server?

0 Answers  

---

What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  

---

What is extent? Types of extents?

0 Answers  

---

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

---

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,

---

Why de-normalization required?

0 Answers  

---