From the stored procedure Pro clan:

1. Some applications can't tolerate the roundtrip latency, so the typical way is to put the business logic inside the stored procedure.

2. DBA wants to guard the database.