Comments SQL

 In SQL, there are two common ways to add comments:

1. Single-Line Comments

   - For single-line comments, you can use the double-dash (`--`) syntax. Anything after the double-dash on the same line is treated as a comment.

   Example:

   -- This is a single-line comment
   SELECT column1, column2
   FROM your_table;

2. Multi-Line Comments

   - For multi-line comments, you can enclose the comment text between `/*` and `*/`. Everything between these delimiters is treated as a comment.

   Example:

   /*
      This is a multi-line comment
      It spans multiple lines
   */
   SELECT column1, column2
   FROM your_table;

Important Notes

- Single-line comments starting with `--` are widely supported in various SQL database systems.

- Multi-line comments enclosed between `/*` and `*/` are also widely supported, but there might be some variations in specific database systems.

Use comments to document your SQL code, provide explanations, or temporarily disable certain parts of the code during testing or debugging. Good commenting practices make your code more understandable and maintainable.