Adding VARCHAR(MAX) Columns
Posted: March 24th, 2022, 2:26 pm
When adding a column to an existing table and selecting either the "varchar(max)" or "nvarchar(max)" option, I am unable to insert anything into those columns. When I checked the size of the columns in a query, the sizes came back as 1 even though the database maintenance page shows "max".
Selecting "varchar" or "nvarchar" and manually adding "max" as the max length seems to work correctly, but I only tested that when creating a new table and not when adding a column to an existing table.