How to insert multiple rows with one insert statement in ms sql server?

0 Answers  

---

How will you optimize a stored procedure optimization?

0 Answers  

---

How to delete duplicate rows from table except one?

0 Answers  

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---

How can we determine what objects a user-defined function depends upon?

0 Answers  

---

how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

---

Define union, union all, minus, intersect?

0 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

What have included columns when we talk about sql server indexing?

0 Answers  

---

what are the types of indexes? : Sql server database administration

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,

---