How to get store procedure result set
This is the sql script to get other SP resultset in our store procedure:
CREATE PROC PROC_X
AS
CREATE TABLE #TmpTable( ... )
INSERT INTO #TmpTable EXEC usp_MySP @1, @2
This is the sql script to get other SP resultset in our store procedure:
CREATE PROC PROC_X
AS
CREATE TABLE #TmpTable( ... )
INSERT INTO #TmpTable EXEC usp_MySP @1, @2
No comments:
Post a Comment