Comments

Comments are indispensable for making code more readable. Comments in SAP HANA sql are delimited in two ways:

Double hyphens “--“. 

The sql parser ignores everything after the double hyphen

select --top 100 all

*

from dummy;

Is parsed as:

select

*

from dummy;

 "/*" and "*/"

The parser ignores eve thing after the first "/*" and the next "*/"

select /*top 100

all*/

*

from dummy;

Is parsed as:

select

*

from dummy;

This will produce a syntax error:

select /*top 100

all*/ */

*

from dummy;

<< Return to table of contents

 Next Lecture: Comments >>>