What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

Why are views required in the sql server or in any other database?

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,

---

What is Right Outer Join?

2 Answers  

---

What are the steps you will take to improve the performance of a poor performing query?

0 Answers  

---

What is the recovery model?

0 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

Wht is SQL Injection Attack ?

3 Answers  

---

Can you give an example of Stored Procedure?

4 Answers   Wipro,

---

what is difference between nchar and char in Sql server ?

3 Answers  

---

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

---