1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Why do we use stored procedures in sql server?

Question Posted / amnish kumar


Why do we use stored procedures in sql server?..

Answer / Durgesh Joshi

Stored procedures are used in SQL Server for several reasons, including: improved performance through reusable code and query optimization, enforcing data integrity through parameter validation and transaction handling, encapsulating complex logic, and securing sensitive data by limiting direct access to tables.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Can you move the resources after pausing the node? : sql server database administration

1 Answers  

What is the maximum size of sql server database?

1 Answers  

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

What are the 3 types of schema?

1 Answers  

How many database files are there in sql server 2000?what are they?

1 Answers  

How to use transact-sql statements to access the database engine?

1 Answers  

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

What happens when converting big values to numeric data types?

1 Answers  

Wht is SQL Injection Attack ?

3 Answers  

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

Why SQL Agent is used?

1 Answers   Abacus,

What new changes are being made in SQL Server?

1 Answers   Blue Star,

For more SQL Server Interview Questions Click Here
Categories