Sql Server, Query Optimization.
maintainable code. The database engine can optimize the execution of encapsulated logic more effectively than when the logic is spread across multiple ad-hoc queries. Reduced network round-trips — When executing a stored procedure, multiple SQL statements can be processed on the server side without