Define self join?

0 Answers  

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

How to access the inserted record of an event?

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

What is an indexed view?

0 Answers  

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

How to access the deleted record of an event?

0 Answers  

---

What are the differences between char and nchar in ms sql server?

0 Answers  

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

How do triggers work?

0 Answers  

---