how to debug or view the result of query in stored procedure.
i am having problem with the stored procedure.mostly i worked with the tables and queries in the code.i am dealing with the stored procedure for the first time.
i only know how to execute stored procedure.(execute stored procedure---->pass the values) and then will get the return value as result.
i dont know how the query in the stored procedure working internally means how to check the result of the query in stored procedure.i am working in the existing project and my previous employees used print @final query,select #111, xyz from table.i dont know how they are viewing the result based on this.
i know that this is a basic question. Any help will be highly appreciated.
