A null statement has no content except for optional pad characters or SQL comments.
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 ...
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 ;
A SEMICOLON that precedes the first (or only) statement of a request is taken as a null statement.
;DROP TABLE temp_payroll;