I'm someone who has written a lot of SQL, but always in-line SQL and I'd like to get more involved with the use of stored procedures. I some general questions:

What is the advantage of using stored procedures over in-line SQL?
Are there any disadvantages of using stored procedures over in-line SQL?
Are there instances where you should always use a stored procedure?
Are there instances where you should skip the stored procedure and just code your query in-line?

Thanks.