explain about stored procedure

Question

explain main use of stored procedure and then give simple example

Munesh Sharma · Answer

https://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure-tutorial/

Abdu Rafeeq · Answer

1:To retrieveinsertdelete 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

Shakti Singh Dulawat · Answer

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/