Need Suggestion about Stored Procedure

Question

In web application,windows application  what should prefer  - 

Stored procedure or Inline query (Means query written in application)