3] Manually write a CREATE PROCEDURE Statement If you’re ... Next, you must add the SQL code specifically for a stored procedure, and it must look similar to the first example above.