How do I Execute SQL Stored Procedures from within another Stored Procedure?

This doesn't check for any errors CREATE PROCEDURE RUN_ALL AS SET NOCOUNT ON EXEC YourProcedureA EXEC YourProcedureB EXEC YourProcedureC RETURN 0 GO.

This doesn't check for any errors.. CREATE PROCEDURE RUN_ALL AS SET NOCOUNT ON EXEC YourProcedureA EXEC YourProcedureB EXEC YourProcedureC RETURN 0 GO.

What I do is create a batch file which executes all SQL scripts within a specific folder using isql command line calls. The batch file simple loops through all files in the folder and executes the script. This process has the advantage of also being able to generate an output file of the results of the script for reference purposes.

If you're asking if you can write a SQL script that references files in the local file system, then no. However, you could create one script file that combines the creation scripts into separate batches, or use an external batch processing tool (like the SQL command line) to run these script files in a batch.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.