Guest User

Untitled

a guest
Feb 18th, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. CREATE PROCEDURE dbo.p1
  2. @Resp INT OUTPUT
  3. AS
  4. SET @Resp = 0;
  5. SELECT * FROM Table1;
  6. GO
  7.  
  8. CREATE PROCEDURE dbo.p2
  9. @Resp INT OUTPUT
  10. AS
  11. DECLARE @tmp table1_type;
  12. INSERT INTO @tmp EXEC dbo.p1 @Resp OUTPUT;
  13. SELECT * FROM @tmp;
  14. GO
  15.  
  16. DECLARE @tmp dbo.table1_type;
  17. DECLARE @Resp INT;
  18. INSERT INTO @tmp EXEC dbo.p1 @Resp OUTPUT;
  19. SELECT * FROM @tmp;
  20.  
  21. DECLARE @tmp dbo.table1_type;
  22. DECLARE @Resp INT;
  23. INSERT INTO @tmp EXEC dbo.p2 @Resp OUTPUT;
  24. SELECT * FROM @tmp;
Add Comment
Please, Sign In to add comment