SQL, C#, VB, .net, asp, JavaScript, you name it. Code samples, Error messages and stuff like that. Please add coments if you think I said something stupid :D or if you have a better idea ... or anything at all ...
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)
No comments:
Post a Comment