A null statement has no content except for optional pad characters or SQL comments.
Example: Using a Semicolon as a 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: Using Semicolons as Null Statements and Statement Separators
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: Using a Semicolon that Precedes the Statement
A SEMICOLON that precedes the first (or only) statement of a request is taken as a null statement.
;DROP TABLE temp_payroll;