>>
>>You're confusing Creating sproc and Executing sproc.
>
>Why are you surprised? <g>

In order to create/update sproc in DB you do

-- create
CREATE PROCEDURE myproc
...
-- update 
ALTER PROCEDURE myproc
...

After that you can excute sproc

myproc ...
-- or
EXEC myproc ...

The EXEC[UTE] is required if there're multiple statement ij a batch. I always use it for concistency.