Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Call a procedure with in procedure in SQL server

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 107
    Comment on it

    Call a procedure with in procedure in SQL server :-

    While working in sql Some times you need to Calling one stored procedure within another stored procedure. So you can implement this using below sample code:---

    //Store Procedure 1
    CREATE PROCEDURE uspTest1
    AS
    BEGIN
      SELECT * FROM Student
    END
    
    //Store Procedure 2
    CREATE PROCEDURE uspTest2
    AS
    BEGIN
         // To call the Procedure uspTest1 in this procedure
         // Its return that Procedure output.
         exec uspTest1     
    END
    

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: