DF007: The length of the datatype is not specified.

Last modified: December 25, 2024

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

Category

BEST PRACTICE

Message

The length of the datatype is not specified.

Description

It is recommended to explicitly specify the length of the (N)VARCHAR, VARBINARY, (N)CHAR, BINARY, DECIMAL, and NUMERIC datatypes in the CAST and CONVERT clauses.

Additional information

It is an optional integer used to specify the length of the target data type, specifically for data types that allow user-defined lengths.

Noncompliant code example

SELECT CAST(FirstName as varchar) AS FirstName
FROM dbo.Customers

Compliant solution

SELECT CAST(FirstName as varchar(128)) AS FirstName
FROM dbo.Customers

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