Need Suggestion about Stored Procedure

Why Use Stored Procedures:
 1.For any complex data work. If you're going to be doing something truly requiring a cursor or temp tables it's usually fastest to do it within SQL Server. 2.When you need to lock down access to the data. If you don't give table access to users (or role or whatever) you can be sure that the only way to interact with the data is through the SP's you create.

Why Use queries:
1.For CRUD when you don't need to restrict data access (or are doing so in another manner). 2.For simple searches. Creating SP's for a bunch of search criteria is a pain and difficult to maintain. If you can generate a reasonably fast search query use that.

yes Of course ......

Thank you all.
I am very much familiar with stored procedure.
I am searching a strong reason to use stored procedure in Web application. Actually i have to explain it to my boss. Currently I am working on windows development. My boss is not prefered for stored procedure for every process. but I often use stored procedure for every process.
If I am making stored procedure for DML operation is it not good practice?

Hi Ravi,
Store procedure is better option in the case of web application, because if you pass inline query, you have to pass the whole query text to the server instead of procedure name. which will increase the data transfer.