What a stored procedure in Sql Server??

Its a prepared SQL Statement that you save before, then you can call this procedure over and over,you can call this procedure from even the SQL Server Console, or from Programming Language using SQLClient, or making the Procedure itself runs periodically or under event.

A stored procedure is nothing more than prepared SQL code that you save so you can reuse the code over and over again.  So if you think about a query that you write over and over again, instead of having to write that query each time you would save it as a stored procedure and then just call the stored procedure to execute the SQL code that you saved as part of the stored procedure.