Checkout.com interview question

Is it better to use a stored procedure or an insert statement for SQL?