Kinder Morgan interview question

Difference between calling stored procedure and Inline SQL query.