Code Analysis

BP004

INSERT without column list

The column list for the insert statement is missing.

The INSERT statement need not have a column list, but omitting it assumes certain columns in a particular order. It likely to cause errors if the table in to which the inserts will be made is changed, particularly with table variables where insertions are not checked. Column lists also make code more intelligible.

Available in

SQL Prompt

SQL Code Guard



Didn't find what you were looking for?