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.




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.

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


set StripComments=0;

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

set StripComments=1;

See also:


Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?