how to fix string or binary data would be truncated in sql server | ProgrammingGeek

Показать описание

How to solve string or binary data would be truncated in SQL? this is very easy to Fix this exception string or binary data would be truncated in SQL.
Its occurred due to smaller nvarchar or varchar length. in details
- If your SQL table column length is less than the string that you want to insert in that column then you see this error.
- To solve this error either you decrease the string length as less as SQL table datatype or increase the SQL table datatype length
- Save.
This exception string or binary data would be truncated in SQL will be solved.

for example,
Table- Student
Column- Name nvarchar(10)
Record- Trump -- its allowed. because trump has 5 characters.
Record- Sara -- its allowed. because trump has 4 characters.
Record- Christina -- it's not allowed. because Christina has more than 5 characters. so you get this exception string or binary data would be truncated the statement has been terminated.

------
This channel covers all the programming tutorial related with .Net- C#, LINQ, VB, SQL, Android, HTML, CSS, jQuery, Crystal Report and Microsoft Report.
So, Please subscribe and keep in touch.

Visit my page in Facebook
------

More Tags
#FixStringOrBinaryDataWouldBeTrancated #SolveStringOrBinaryDataWouldBeTrancated #TheStatemetHasBeenTerminated

string or binary data would be truncated in sql server,how to fix string or binary data would be truncated in sql,string or binary data would be truncated,fix string or binary data would be truncated,solve string or binary data would be truncated,fix this exception string or binary data would be truncated,string or binary data,statement has been,sql error,sql,how to,fix string or binary data trancated