Answer / Tulika Chatterjee

A recursive stored procedure is a stored procedure that calls itself repeatedly to process hierarchical data or iterative tasks. It has at least one RECURSIVE common table expression (CTE) in its definition, which defines the base case and the recursive case for the procedure.

What is the difference between Clustered and Non-Clustered Index?

1 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

How to copy the tables, schema and views from one sql server to another?

1 Answers  

---

What is #table in sql server?

1 Answers  

---

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1 Answers  

---

How to connect a database with sql express.?

1 Answers   MCN Solutions,

---

where the connection string store in the database

1 Answers   HCL, Wipro,

---

Tell me what are the essential components of sql server service broker?

1 Answers  

---

What stored by the msdb? : sql server database administration

1 Answers  

---

Explain the categories of stored procedure?

1 Answers  

---