For debugging purpose I have put a print statement in the procedure. When I execute the procedure using exec proce_name, the value returned by print statement is ‘Failure’
But when I try to execute the procedure through query analyser, the value returned by print is ‘Success’
How come the same piece of code is giving different results?
