daily pastebin goal
4%
SHARE
TWEET

Untitled

a guest Feb 18th, 2019 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top