diffrence between function and procedure

5 Answers   Wipro,

---

What the difference between UNION and UNIONALL?

0 Answers   HCL,

---

How does clustered and non clustered index work?

0 Answers  

---

What are the different types of upgrades that can be performed in sql server?

0 Answers  

---

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---

---

What is nolock?

0 Answers  

---

What are subqueries in sql server?

0 Answers  

---

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

---

What is the system function to get the current user's user id?

3 Answers   TCS,

---

How to convert a table data in XML format in sql server?

0 Answers  

---

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

---

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

1 Answers   HCL,

---