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.
First of all you should understand the reason of this error string or binary data would be truncated the statement has been terminated in c# sql, as.net.
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 character.
Record- Sara -- its allowed. because trump has 4 character.
Record- Christina -- its not allowed. because Christina has more than 5 character. 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.
https://www.youtube.com/channel/UCyc31q0rUGp-s07Ebn1x65g

Visit my page in Facebook
https://www.facebook.com/programminggeek7
------

More Tags
#FixStringOrBinaryDataWouldBeTrancated #SolveStringOrBinaryDataWouldBeTrancated #TheStatemetHasBeenTerminated

programminggeek,string or binary data would be truncated in sql server,string or binary data would be truncated error,string or binary data would be truncated error in sql,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