Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Comments

Comments are used to attach explanatory text to SQL statements or statement blocks. The database server does not execute comments.

Several comment indicators are available in SQL Anywhere.

• -- (Double hyphen)    The database server ignores any remaining characters on the line. This is the SQL/2003 comment indicator.

• // (Double slash)    The double slash has the same meaning as the double hyphen.

• /* ... */ (Slash-asterisk)    Any characters between the two comment markers are ignored. The two comment markers may be on the same or different lines. Comments indicated in this style can be nested. This style of commenting is also called C-style comments.

• % (Percent sign)    The percent sign has the same meaning as the double hyphen, if the percent_as_comment option is set to On. It is recommended that % not be used as a comment indicator.

• The following example illustrates the use of double-hyphen comments:

  CREATE FUNCTION fullname ( firstname CHAR(30),
           lastname CHAR(30))
  RETURNS CHAR(61)
  -- fullname concatenates the firstname and lastname
  -- arguments with a single space between.
  BEGIN
     DECLARE name CHAR(61);
     SET name = firstname || ' ' || lastname;
     RETURN ( name );
  END
  

• The following example illustrates the use of C-style comments:

  /*
     Lists the names and employee IDs of employees
     who work in the sales department.
  */
  CREATE VIEW SalesEmployees AS
  SELECT EmployeeID, Surname, GivenName
  FROM Employees
  WHERE DepartmentID = 200