what is the procedure in SQL server to not execute anything(T SQL commands) but outputs the commands it would execute

what is the procedure in SQL server to not execute anything(T SQL commands) but outputs the com开发者_如何学Gomands it would execute

---

There isn't one unless you are using dynamic SQL where you'd use PRINT

You can see a stored proc definition but this won't show you any actual parameter values etc

---

Are you thinking of SET SHOWPLAN_TEXT ON?