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!