Using Stored Procedure in ms sql provides many benefits.

Below are the main benefits.

It can reduce interference in application code.

Developers can solve many processes in the application by the stored procedure. So they don't have to recompile the application for every change.

Performance

Since the Stored procedure is stored on the database server, it reduces the traffic between the application and the server. It provides performance benefits in large applications.

Speed

The stored procedure is compiled only once at the time of creation and is cached on the server. Therefore, repeated compilation is not required during the operation of the procedure, therefore, the speed of work increases.

Security

Stored procedures do not have direct access to tables. Therefore, it prevents unauthorized processing of records inside tables.