Capita Interview Question

explain the need for stored procedures when integrating with SQL server