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

Last modified: December 25, 2024

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)

Want to find out more?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by SQL Complete.

All features

All features

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

Request a demo

Request a demo

If you consider employing this tool for your business, request a demo to see it in action.

SQL Complete logo

Ready to start using  

SQL Complete?

Download a FREE 14-day trial