What is Stored Procedure?
A stored
procedure is a pre-compiled group of Transact-SQL statements. A
stored procedure is a group of SQL statements that has been created and stored
in the database . Stored procedure will reduce network traffic and increase the performance.
It is
always recommended to create Stored Procedure instead of
writing Inline queries so that we can just call the Stored Procedures whenever
required instead of writing Inline queries each time.
