String data types (char
, varchar
, nchar
, nvarchar
) default to a size of 1 if no size is
specified in the declaration. For char
and nchar
this is confusing at best, but it is most probably a mistake for
varchar
and nvarchar
.
This rule raises an issue when no size is specified for varchar
or nvarchar
.
Noncompliant code example
DECLARE @myStr varchar; -- Noncompliant
Compliant solution
DECLARE @myStr varchar(255);