Home
Size should be specified for varchar variables and parameters
Rule description
- Size should be specified for varchar variables and parameters
Non-compliant Code Example
DECLARE @find varchar; --Non complaint code (Variable declared as a varchar without size) SET @find = 'Man%'; SELECT p.LastName, p.FirstName, ph.PhoneNumber FROM Person.Person AS p JOIN Person.PersonPhone AS ph ON p.BusinessEntityID = ph.BusinessEntityID WHERE LastName LIKE @find;
Compliant Code Example
DECLARE @find varchar(30); --Complaint code (Variable declared as a varchar with size) SET @find = 'Man%'; SELECT p.LastName, p.FirstName, ph.PhoneNumber FROM Person.Person AS p JOIN Person.PersonPhone AS ph ON p.BusinessEntityID = ph.BusinessEntityID WHERE LastName LIKE @find;