![How to avoid the error "string or binary data would be truncated" and insert string with truncation in SQL Server? | My Tec Bits How to avoid the error "string or binary data would be truncated" and insert string with truncation in SQL Server? | My Tec Bits](https://www.mytecbits.com/wp-content/uploads/SQL-String-Or-Binary-Data-Would-Be-Truncated-01.png)
How to avoid the error "string or binary data would be truncated" and insert string with truncation in SQL Server? | My Tec Bits
![SQL-SERVER: how to get the maximum length of a variable of VARCHAR help - Database Administrators Stack Exchange SQL-SERVER: how to get the maximum length of a variable of VARCHAR help - Database Administrators Stack Exchange](https://i.stack.imgur.com/ZDMZO.png)
SQL-SERVER: how to get the maximum length of a variable of VARCHAR help - Database Administrators Stack Exchange
![Error Invalid string or Buffer length while transfering data from Microsoft SQL Server 2008 to SAP HANA | SAP Blogs Error Invalid string or Buffer length while transfering data from Microsoft SQL Server 2008 to SAP HANA | SAP Blogs](https://blogs.sap.com/wp-content/uploads/2015/02/err_41_649550.png)
Error Invalid string or Buffer length while transfering data from Microsoft SQL Server 2008 to SAP HANA | SAP Blogs
![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
![Error Invalid string or Buffer length while transfering data from Microsoft SQL Server 2008 to SAP HANA | SAP Blogs Error Invalid string or Buffer length while transfering data from Microsoft SQL Server 2008 to SAP HANA | SAP Blogs](https://blogs.sap.com/wp-content/uploads/2015/02/dav_1_649536.png)