Incorrect Syntax: Create Procedure must be the only statement in the batch
<p>This question has been asked before but it all involved using "go" which I am not in need of here, at least I believe so.</p>

<p>I am following this tut <a href="https://www.youtube.com/watch?v=-xMGwiV5A6o" rel="nofollow">https://www.youtube.com/watch?v=-xMGwiV5A6o</a>, near the 1:25 mark exactly.  And his seems to execute while mine doesn't.</p>

<pre><code>    Select * From Snacks

    Create Proc spGetSnackByID
    @Id int
    as

    Begin
    Select Id, Name, Location
    from Snacks where Id = @Id
    End
</code></pre>

<p>Here is the exact error, being highlighted with the "BEGIN" statement:</p>

<p>"Msg 111, Level 15, State 1, Procedure spGetSnackByID, Line 7
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch."</p>