Last post Apr 08, 2015 08:37 AM by tvb2727
Apr 08, 2015 08:17 AM|tvb2727|LINK
Print 'This is a Test'
Comments okay to leave in code that goes to production or do they need to be removed once you execute the final stored procedure?
Apr 08, 2015 08:31 AM|NiravVyas|LINK
Simple PRINT statements would have negligible effect on performance in your stored procedure as I think they would only matter when you run your stored procedure in Management Studio. If you have used PRINT in some loop then I would suggest you remove it
before updating your stored procedure to production as you never know it may eat up some of milliseconds or even more, best thing is to test it out simply running SP with and without PRINT and note down the time, it will give you most satisfactory answer.
Apr 08, 2015 08:31 AM|Kulrom|LINK
Generally speaking, the PRINT statements should be negligible unless you are looping through lots of records.
I usually leave the PRINT statements in there.
Apr 08, 2015 08:37 AM|tvb2727|LINK