Why Stored Procedure is beneficial in asp.net

 These are some import ants key points for making Stored     Procedure beneficial for asp.net

1. 
   
   1)    All stored Procedure creates in Database.
   2)    Created Stored Procedure will be executed in Database.
   3)    It provides the better performance as compare to Inline Query.
   4)    It is a Pre Complied File.
   5)    Stored Procedure also provides the security
   
   
   SPs are an advanced feature in SQL server that offers you to create compile and run or execute SQL statements in the server itself, improve the performance of your application.
   In short, write SQL queries in a specific format in the SQL server and call them from your application, instead of writing queries inside your program code.