Subroutines in TSQL

Is there a way to define a sub-routine in a stored procedure so that I could invoke it multiple times when executing my stored procedure. For example, I need to perform a set of commands several times but using different variables. I want to define this routine as a procedure with parameters and call it within my stored procedure. Creating this subroutine as a stored procedure by itself is not worth it, because it is very specific to the stored procedure I'm writing.
I looked in the TSQL manual and couldn't find any reference of defining a local procedure the way it is done in most of the languages I know.
LVL 3
mgokmanAsked:
Who is Participating?
 
Victor SpiridonovCommented:
You can't define a subroutine in a stored procedure. The best  you can do is  create a separate stored procedure and pass parameteres to it. You can also try to use unconditional branching (GOTO). But in this case you will have to worry about returning to the right label and it is not always possible.
0
 
mgokmanAuthor Commented:
That's what I thought.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.