Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

What is partitioned view?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What does null mean?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

What is sub-query in sql server? Explain its properties.

0 Answers  

---

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

Do you know the isolation level that sql server support?

0 Answers  

---

Why we should not use triggers?

0 Answers  

---

How to enter binary string literals in ms sql server?

0 Answers  

---