Answer / g.ramesh

Outter Join Produce result set,which contain matched rows
and has well has unmatched rows.

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

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,

---

Can you force a query to use a specific index?

0 Answers  

---

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---

What are trace flags?

0 Answers  

---

Difference between primary key and clustered index?

0 Answers  

---

What are the difference between primary key and unique key? : sql server database administration

0 Answers  

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

What is compression - row-level and page-level compression?

0 Answers  

---

What is the difference between constraints and triggers?

9 Answers   Wipro,

---