Stored Procedure

Question

Hi i am working on Stored Procedure. i want to check query written in this? how can i check ? Please help

Amit Gupta · Answer

You can use Exec yourStoreProcedureName

Nitin Sontakke · Answer

Showing code always helps. There so many ways in which you might have written the code we cannot possibly imagine. Why not execute the stored procedure itself? If you want to just execute that query: 1/ You can just take that out and execute it in SSMS or 2/ If it is a simple query just select the entire query and press F5. Again without source how can we possible give the correct answer?