Thanks for the question, the batch separator can cause some headaches for newbies.

But I have some suggestions on how to improve your code:

1. Do not use "sp_" as stored procedure prefix

2. Specify the schema when referring to objects

3. Explicitly specify nullability for all columns in the table declaration.

4. All tables should have a primary key.

I know this is only test code, but the rules should always apply, since non-experienced users easily pick up bad coding styles.