Cacher is the code snippet organizer for pro developers

*/
RETURN can be used as the first line of a procedure to stop someone from executing the entire at the same time. For example, if you 
have a procedure that needs to be run in chunks manually, you can put the RETURN as the first line of the procedure to stop the procedure
from EXECecuting the entire thing at once via F5 or via Execute option in Object Manager.
*/

CREATE PROCEDURE thisismyprocedure
AS

RETURN -- will stop procedure before the UPDATE below is executed if entire procedure is run at the same time

UPDATE products3 set price = price * 2 where id =1002