Guest User

Untitled

a guest
Jan 19th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. Id Name Age Address State Country
  2. 1 ManiS 25 aaaa bbb ccc
  3.  
  4. Declare @testTbl Table (RowId int identity, Name nvarchar(100), Age int);
  5. INSERT INTO @testTbl(Name,Age) EXEC [Test_Sp] 23;
  6. Select * from @testTbl;
  7.  
  8. INSERT INTO Temp
  9. Exec [Test_Sp] 23;
  10.  
  11. INSERT INTO @testTbl(Name,Age)
  12. select name,age from temp
  13.  
  14. INSERT INTO @testTbl(Name,Age) EXEC [Test_Sp] 23,true;
Add Comment
Please, Sign In to add comment