SQL Database Concepts Question:
Download Job Interview Questions and Answers PDF
List down some advantages of SQL Stored procedure?
Answer:
By using stored procedures we can reuse the code.
Stored procedure helps in reducing network traffic and latency.
Stored procedures provide better security to your data.
Stored procedure is cached in SQL Server’s memory. So it helps to reduce the server overhead. It also enhances application performance.
Stored procedures help us in the encapsulation of the code. The code of the stored procedure can be changed without affecting application.
Stored procedure helps in reducing network traffic and latency.
Stored procedures provide better security to your data.
Stored procedure is cached in SQL Server’s memory. So it helps to reduce the server overhead. It also enhances application performance.
Stored procedures help us in the encapsulation of the code. The code of the stored procedure can be changed without affecting application.
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain what is the difference between a Local and a Global temporary table? | Do you know what is Lock Escalation? |