• Firstly, "I have two stored procedures" suggested to me that the scripts we were executing were the actual stored procedures not necessarily the create scripts depicted.

    This may well be a terminology deficiency on my part, I resorted to flipping a coin as to which way I took the question.

    Secondly, I would have been wrong in any case because I tested this in SQL Server 2012 (since no version was specified I considered this valid):

    Both create scripts execute successfully and both stored procedure scripts fail when actually executed (obviously).

    EDIT: spelink.