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;