Example: Null Statement
The semicolon in the following request is a null statement.
/* This example shows a comment followed by a semicolon used as a null statement */ ; UPDATE Pay_Test SET ...
Example: Null Statement and Statement Separator
The first SEMICOLON in the following request is a null statement. The second SEMICOLON is taken as statement separator.
/* This example shows a semicolon used as a null statement and as a statement separator */ ; UPDATE Payroll_Test SET Name = 'Wedgewood A' WHERE Name = 'Wedgewood A' ; SELECT ... -- This example shows the use of an ANSI component -- used as a null statement and statement separator ;
Example: Single Null Statement
A SEMICOLON that precedes the first or only statement of a request is taken as a null statement.
; DROP TABLE temp_payroll;