Networks

Ask something
Question Locked

Debugging a Stored procedure in SQL server

0 helpful
3 replies

by aparna.vpai

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by chitranjanmca09

hi aparna
how r u
help me aparna to declare cursor
i want to use cursor in my site
but
problem creating to declare cursor

This discussion is closed to new replies.