execute a stored procedure in another stored procedure in sql server

Solutions on MaxInterview for execute a stored procedure in another stored procedure in sql server by the best coders in the world

showing results for - "execute a stored procedure in another stored procedure in sql server"
Jannik
01 Nov 2016
1// procedure 1
2BEGIN
3   DECLARE @Results TABLE (Tid INT PRIMARY KEY);
4
5   INSERT @Results
6   // call procedure 2 from procedure 1
7   EXEC Procedure2 [parameters];
8   SET @total 1;
9
10END
11SELECT @total