Answer / Vaibhav Dixit

Stored procedures offer several advantages in SQL Server: 1. Improved performance as compiled and optimized code reusability, reducing network traffic and execution time. 2. Enhanced data security through encapsulation and access control at the database level. 3. Consistency through standardization of operations, ensuring that processes are executed in the same way every time. 4. Reduced error rates due to less user interaction, as users simply call the stored procedure with required parameters. 5. Improved maintainability by allowing modifications to be made in a centralized location, reducing the risk of inconsistencies across different applications.

select names starts with a,b,c

8 Answers   Scope International,

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

What command do we use to rename a db?

5 Answers   IBM,

---

What is the native system stored procedure to execute a command against all databases?

1 Answers  

---

How can you fetch alternate records from a table?

1 Answers  

---

What is instead of trigger sql server?

1 Answers  

---

What are the different types of replication you can set up in sql server?

1 Answers  

---

How to execute stored procedure in select statement sql server?

1 Answers  

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

How to genrate automaticlly empid like gt001

4 Answers  

---

What are system databases in ms sql server?

1 Answers  

---