HPlogo ALLBASE/SQL Reference Manual: HP 9000 Computer Systems > Chapter 1 Introduction

Using Comments within SQL Statements

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

You can initiate comments within any SQL statement or ISQL prompt either by prefixing each line of the comment with two hyphens or with the combination of slashes and asterisks at the beginning and end of the comments:

   SELECT *
     FROM PurchDB.SupplyPrice          
    WHERE PartNumber = '1723-AD-01'    
      AND DeliveryDays < 30
 
   --This statement selects values from the SupplyPrice table based on
   --part number and delivery days.
 
   SELECT *
     FROM PurchDB.SupplyPrice          
    WHERE PartNumber = '1723-AD-01'    
      AND DeliveryDays < 30
 
   /*This statement selects values from the SupplyPrice table based on*/
   /*part number and delivery days.*/
Feedback to webmaster