[Solved] This procedure not working


The problem is not at the procedure it is at the calling. When you call the stored procedure, you need to declare and pass in the required parameter

declare  @NAME VARCHAR(50), 
         @CITY VARCHAR(200), 
         @MOBILE NUMERIC(20)

execute GETDETAIL @AGE    = 21, 
                  @NAME   = @NAME OUTPUT, 
                  @CITY   = @CITY OUTPUT, 
                  @MOBILE = @MOBILE OUTPUT

SELECT @NAME, @CITY, @MOBILE

0

solved This procedure not working