Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE dbo.p1
- @Resp INT OUTPUT
- AS
- SET @Resp = 0;
- SELECT * FROM Table1;
- GO
- CREATE PROCEDURE dbo.p2
- @Resp INT OUTPUT
- AS
- DECLARE @tmp table1_type;
- INSERT INTO @tmp EXEC dbo.p1 @Resp OUTPUT;
- SELECT * FROM @tmp;
- GO
- DECLARE @tmp dbo.table1_type;
- DECLARE @Resp INT;
- INSERT INTO @tmp EXEC dbo.p1 @Resp OUTPUT;
- SELECT * FROM @tmp;
- DECLARE @tmp dbo.table1_type;
- DECLARE @Resp INT;
- INSERT INTO @tmp EXEC dbo.p2 @Resp OUTPUT;
- SELECT * FROM @tmp;
Add Comment
Please, Sign In to add comment