Answer / Aarti Martolia

"Stored procedures offer several benefits, including improved application performance due to reduced network traffic and faster execution time, increased security as they can be secured at the server level, easier code maintenance by encapsulating complex logic, improved error handling with customized error messages, and reusability of SQL code across multiple applications."n

what is a traditional network library for sql servers? : Sql server database administration

1 Answers  

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1 Answers  

---

What is sql server management studio? : sql server management studio

1 Answers  

---

What are a scheduled jobs or what is a scheduled tasks?

1 Answers  

---

How efficient you are in oracle and SQL server?

0 Answers   CGI,

---

Tell me about pre-defined functions of sql?

1 Answers   EXL,

---

What command do we use to rename a db, a table and a column?

1 Answers  

---

What is the difference between having and where clause?

4 Answers  

---

How to insert and update data into a table with "insert" and "update" statements?

1 Answers  

---

What is service broker? : sql server database administration

1 Answers  

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

What is a deadlock and what is a live lock?

1 Answers  

---