Monday, March 12, 2012

how to call stored procedure from another stored procedure?

is it possible to call a stored procedure from another stored procedure?Inside your first Stored Procedure:

exec <name of SP to run> <Eventual Parameters this SP requires>

Here is a link to all you want to know about executing SPs from other SPs. You can even Execute SPs on other SQL Servers.

No comments:

Post a Comment