Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored procedure calling code section

Status
Not open for further replies.

celinel

Programmer
Jun 14, 2001
1
CA
Hi all,
I am programming a stored procedure. I know it can call another stored procedure but is it possible to call a code section withing the same stored procedure, or a seperate file?

Any Suggestions?

Thanks!
 
The GOTO statement allows you to jump to a specific code section.

1. Provide a label for your code section (e.g. DoStuff). Don't forget the colon.
Code:
DoStuff:
Select col_a from table_b

2. Use GOTO to jump to the code section.
Code:
GOTO DoStuff
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top