![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
![0384 – SQL Server – Basics – Implicit Conversion – Blank strings (”) are treated as integers | SQLTwins by Nakul Vachhrajani 0384 – SQL Server – Basics – Implicit Conversion – Blank strings (”) are treated as integers | SQLTwins by Nakul Vachhrajani](https://nakulvachhrajani.files.wordpress.com/2016/08/384_implicit-conversions_01.jpg?w=640)
0384 – SQL Server – Basics – Implicit Conversion – Blank strings (”) are treated as integers | SQLTwins by Nakul Vachhrajani
![sql server - Convert string numeric values with comma as decimal separator to NUMERIC(10, 2) - Database Administrators Stack Exchange sql server - Convert string numeric values with comma as decimal separator to NUMERIC(10, 2) - Database Administrators Stack Exchange](https://i.stack.imgur.com/cgTz5.png)