| Home | Previous Lesson: Declaring a Stored Procedure Next Lesson: Executing a Remote Stored Procedure |
To execute a stored procedure, you simply use the EXECUTE command in your PowerScript:
EXECUTE TestProc1();
This is similar to the cursor's OPEN command, so it won't surprise you to know that we can also use the FETCH command to retrieve the data.
| Home | Previous Lesson: Declaring a Stored Procedure Next Lesson: Executing a Remote Stored Procedure |