##BD Tag

The ##BD tag defines a batch. Batches are defined as SQL batches that contain a CREATE PROCEDURE statement. If the CREATE PROCEDURE is missing, the batch will not be processed.

Since the ##BD is not legal SQL syntax, it must appear between comment tags. The tag may be between multiline comment tags (/* ... */), but only the first line will be read. If the ##BD line is intended to be a multiline comment, a ##BD must appear on the line immediately before the text to form part of the comment. ##BD tags can contain valid HTML to assist in formatting.

Syntax

-- ##BD Comment

Where Comment is the description of the individual procedure

Example

-- ##BD The product update procedure (spUpdateProduct) modifies the product table,
-- ##BD and product availability table with the new details.

Sample Output

Taken from the sample.chm file, this detail shows the fully qualified procedure name, with the batch definition highlighted.