Best Answer · By JanBask MS SQL Server Expert
Rachit Gupta JanBask Expert
Answered on Jan 20, 2020
Stored procedure is a collection of SQL statements that are stored on a SQL server. Its performance is better than the queries executed separately as the query plan is stored in the server which helps in executing the statements early. Variables can be passed into the procedure and we get back the out variable/ datasets. You can retrieve them whenever required
Was this helpful?
