How to Use return, break, and continue in SQL Server

1. Return: Exit unconditionally from the query or process. It can be used to exit from the process, batch processing, or statement block at any time. The statement after return is not executed. If it is used for stored procedures, return cannot return NULL values. If yes, a warning message is generated and a value of 0 is returned.
2. Break: exit while or if... The innermost loop in the else statement. Execute any statement that appears after the end keyword. The end keyword is the end mark of the loop. If testing usually starts break, but not always.

3. Continue: Start the while loop again. Any statement after the continue keyword is ignored.
In short: reak or continue. The break statement exits the innermost while loop, and the continue statement restarts the while loop. For example, if no other row can be processed,ProgramThe break statement may be executed. For exampleCodeTo execute the continue statement.