While "it depends on the circumstances and here's why" is the ideal answer, such questions rarely get those answers.
On one of the sister sites to SO, there's a post about pros and cons on their meta - https://softwareengineering.meta.stackexchange.com/questions... - such questions are often a moderation headache when you get the inevitable spam and the poor quality answers of "I can't believe anyone didn't mention XYZ".
Look at https://stackoverflow.com/questions/15142/what-are-the-pros-... and start reading through and consider the one that starts out with "@Keith" responding to a different answer or "A SQL stored proc doesn't increase the performance of the query" being the entirety of the answer.
Such questions, when left open can get awful answers that are difficult to clean up.