Skip to main content Skip to complementary content

StripComments

If this variable is set to 0, stripping of /*..*/ and // comments in the script will be inhibited. If this variable is not defined, stripping of comments will always be performed.

Syntax:  

StripComments

 

Certain database drivers use /*..*/ as optimization hints in SELECT statements. If this is the case, the comments should not be stripped before sending the SELECT statement to the database driver.

Information note It is recommended that this variable be reset to 1 immediately after the statement(s) where it is needed.

Example:  

set StripComments=0;

SQL SELECT * /* <optimization directive> */ FROM Table ;

set StripComments=1;

Learn more

 

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!