Sorry,
this question is relevant to Triggers, not stored proc.
I'm sure it's the same, as they both use the same language though.

-Ryan