Thursday, June 2, 2011

SQL - turn debug on-off

This is what I do in stored procedures to turn debug print stuff on and off


DECLARE @isDebug BIT; SET @isDebug = 0; IF @isDebug = 0 BEGIN SET NOCOUNT ON END
/* ... sql stuff ... */
IF @isDebug = 1 PRINT (@strSQL)