DF003: The column list for the INSERT statement is missing.

The topic describes the DF003 T-SQL code analysis rule.

Category

BEST PRACTICE

Message

The column list for the INSERT statement is missing.

Description

It is recommended to explicitly specify the column list for the INSERT statement. This results in better code readability and helps avoid errors caused by changes to the table structure.

Noncompliant code example

INSERT INTO dbo.Customers VALUES(@FirstName, @LastName)

Compliant solution

INSERT INTO dbo.Customers(FirstName, LastName) VALUES(@FirstName, @LastName)