Capita interview question

explain the need for stored procedures when integrating with SQL server