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  

---

Explain about local stored procedure?

0 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

How to store and query spatial data?

0 Answers  

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

---

How do I find my localdb version?

0 Answers  

---

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

0 Answers  

---

What are tasks?

3 Answers   Wipro,

---

List out the difference between union and union all in sql server?

0 Answers  

---

Explain the categories of stored procedure?

0 Answers  

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---