Lowell (7/25/2013)
--fails
EXEC iSPRINT 'This is a teststring to print time: ' , CONVERT(varchar(112,getdate())
--works
EXEC iSPRINT 'This is a teststring to print time: ' , 'when Spongebob','IsOn Nickelodeon'
But this does not fur-fill a purpose anymore.
I have thought of a work around, I will global substitute all PRINT statements with a
Because this also affects the functional print statements, the functional print statements will be replaced by a stored procedure (eg. Pxrint). There are far less functional print statements, these I have to edit one at the time, but there are far less of them.
Substituting the '-- PRINT' for 'PRINT' will switch on the teststatements.
The other way around will switch off the test statements.
thanks for your suggestions and your thoughts,
ben brugman