Break « Transact SQL « SQL Server / T-SQL






1.BREAK exits the WHILE structure, resuming execution after the END statement
2.BREAK stops the execution of the statements inside the block