explain about stored procedure

1:To retrieve,insert,delete and update data from database

2.We can modify without affecting code part(like C#code)

3:Reuse

eg: create procedure procedureName @name varchar(50)

as begin

select * from tableName where name=@name

end

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.

Please follow Step By Step Tutorialhttps://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure-tutorial/