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
?
精彩评论