![Use of MAX data types when over >8000 characters. (error exceeds the maximum allowed for any data type (8000). Use of MAX data types when over >8000 characters. (error exceeds the maximum allowed for any data type (8000).](https://i1.wp.com/www.thebuttonfactory.nl/wp-content/uploads/2013/09/varchar_example.jpg)
Use of MAX data types when over >8000 characters. (error exceeds the maximum allowed for any data type (8000).
![SQL SERVER - Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH - SQL Authority with Pinal Dave SQL SERVER - Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2018/12/col_length.jpg)
SQL SERVER - Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH - SQL Authority with Pinal Dave
![How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? - Interview Question of the Week #218 - SQL Authority with Pinal Dave How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? - Interview Question of the Week #218 - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2019/03/limittext.jpg)
How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? - Interview Question of the Week #218 - SQL Authority with Pinal Dave
![sql server 2016 - how to resolve The data types nvarchar(max) and uniqueidentifier are incompatible in the add operator - Database Administrators Stack Exchange sql server 2016 - how to resolve The data types nvarchar(max) and uniqueidentifier are incompatible in the add operator - Database Administrators Stack Exchange](https://i.stack.imgur.com/uP1ii.png)