Answer / Bhawna Sagar

A stored procedure is a prepared SQL code object that you can save, so it can be reused multiple times. It contains a collection of SQL statements and functions that are used to perform a specific task in a database. Stored procedures can accept input parameters, return output parameters, or even return a result set.

Define cursor locking

1 Answers  

---

Can group by be used without aggregate functions?

1 Answers  

---

What is @@error in sql?

1 Answers  

---

What are the differences between char and nchar in ms sql server?

1 Answers  

---

Explain the microsoft sql server delete command?

1 Answers  

---

What purpose does the model database server?

1 Answers  

---

Why use “pivot” in sql server?

1 Answers  

---

How to receive output values from stored procedures?

1 Answers  

---

How to select some specific rows from a table in ms sql server?

1 Answers  

---

What is the difference between coalesce() & isnull()?

1 Answers  

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

How to find Duplicate Records In table?

1 Answers   HCL,

---