Accodare righe tra tabelle identiche (o quasi) - c'è un modo veloce pe...

USE tempdb;
GO

CREATE PROCEDURE dbo.up_Proc1(
@Param1 int OUTPUT,
@Param2 int OUTPUT
)
AS
SET @Param1 = 10;
SET @Param2 = 20;
GO

CREATE PROCEDURE dbo.up_Proc2(
@Param1 int,
@Param2 int
)
AS
SELECT @Param1 AS Param1, @Param2 AS Param2;
GO

DECLARE @Param1 int;
DECLARE @Param2 int;

EXEC dbo.up_Proc1 @Param1 OUTPUT, @Param2 OUTPUT;
EXEC dbo.up_Proc2 @Param1, @Param2;

/* Output:

Param1      Param2
----------- -----------
10          20

(1 row(s) affected)

*/

DROP PROCEDURE dbo.up_Proc1, dbo.up_Proc2;