CODEWITHSUNDEEP
sqlsql-servervarcharsqldatatypesvarcharmax
Alok Singh
Alok Singh

Reputation: 174

SQL Datatype Varchar(max) Vs Varchar(8000)

What I understand: If I define a column with Varchar(100) and then store only 40 bytes then SQL will allot only 40 bytes for that cell. What I want to know: Now, if I define all my cells as Varchar(8000) then what is the problem? Why should I even use Varchar(100) or Varchar(anything else except 8000)?

Also, Why not just use Varchar(max) instead of varchar(8000) as I understand 8000 is the max value.

Upvotes: 1

Views: 68

Answers (0)

Related Questions