List few advantages of Stored Procedure.
· Stored procedure can reduced network traffic and latency, boosting application performance. · Stored procedure execution plans can be reused, staying cached in SQL Server’s memory,reducing server overhead. · Stored procedures help promote code reuse. · Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients. · Stored procedures provide better [...]
