How to use RETURN keyword in Stored Procedure in SQL Server?
How to use RETURN keyword in Stored Procedure in SQL Server?
Ask by Steilla Mitchel
Updated 21 Oct 2021
Stored Procedure with RETURN keyword:
The use of RETURN keyword in SQL Stored Procedure is to return the process after executing a specific part of stores procedure. If you have created a large stored procedure and you want to execute or run only some part of that stored procedure and then close execution then you can use the RETURN keyword after that specific part of code that you want to execute. The RETURN keyword return the process of execution after process a specific part of code.
Ex-