166 SQL String or Binary Data Would be Truncated The Statement has been Terminated
166 SQL String or Binary Data Would be Truncated The Statement has been Terminated. Here I will explain how to solve the problem of “string or binary data would be truncated. The statement has been terminated.” in sql server. I am trying to insert data into one table using SQL queries at that time I got error like “String or binary data would be truncated. The statement has been terminated.” Actually this problem because of I declared column datatype varchar(25) but I am inserting data more than 25 characters in that column. To solve this problem I modified column datatype varcha (25) to varchar(50). String or binary data would be truncated. The statement has been terminated. (0 row(s) affected) Follow Us On Facebook : www.facebook.com/yoctokarthi Twitter : www.twitter.com/yoctokarthi Google Plus : https://plus.google.com/+YoctoKarthi HackerRank : www.hackerrank.com/yoctokarthi Instagram : www.instagram.com/yoctokarthi Tags : Asp.net JQuery General C#.Net VB.NET Code Snippets Javascript SQL Server Gridview asp.net mvc c# JQuery Plugins Errors Interview Questions Fileupload Ajax mvc DropdownList AngularJS JSON validations Google API AutoComplete Google MAPS CSS DatePicker IISServer Modalpopup Windows Application Membership Authentication CheckBox Crystal Reports HTML ExcelSheet OOPS Concepts SharePoint jQuery UI ExportGridviewData XML SendMail WebService Entity Framework UpdatePanel AjaxModalPopupExtender Bootstrap Google Maps API InternetTips SlideShow ToolTip Visual Studio WCF Menu Progressbar Razor View SQL Joins web.config ADO.NET DataGridview Repeater Web API YouTube AjaxAsyncFileUpload Cookie DataList EncryptionandDecryption LightBoxEffect RDLC Report RadioButtonList Windows Service loading Image Accordion Menu Charts CheckBoxList Dynamic Controls Facebook Fixed Header on Scroll Global.asax IEnumerable SSRS Twitter jQuery Menu Access Database Blog Statistics Generic List KeyBoard Key Codes ListBox MultilineTextbox Polymorphism UI Grid ZIP UNZIP Files jQuery Cookie setInterval setTimeOut 360 Degree View Plugins ASP AjaxAutoCompleteExtender AjaxTabContainer Average rating Captcha Flip Effect HTML5 LINQ Linkedin MySQL News Ticker in jQuery PDF Viewers Product Reviews QueryString Resize Image Reviews SQL Constraints SQL Server 2008 R2 Session Timeout SiteMap Social Media Bookmark Plugins ThumbnailsGeneration UserName Check Visitors Count Windows 8 app.config asp.net core jQuery Media Plugins sorting windows 10 3-TierArchitecture AbstractVsInterface ActiveDirectory Advertise Ajax Calendarextender Ajax ConfirmbuttonExtender AjaxAccordionControl AjaxCalendarExtender AjaxCollapsiblePanelControl AjaxDragPanelExtender AjaxPasswordStrength AjaxRatingControl AjaxSlideshowExtender Arraylist Assembly Authorization Caching Chatting Plugins CodingStandards Containers Custom Right Click Menu Dapper DataGrid Docker Donate Error Log Forums Google Charts Gzip Compression Hyperlinks IP Address ImportContacts Lync MCC Award MVP Award Northwind Database Notification Bar Panorama Image Viewer Plugins Print DIV Projects RSSFeeds Read/Write text file ReadOnlyValues RichTextBox Scrollbar Setup File Spell Checker TFS Testimonial Example Testing TextArea Trace Mobile Number Try Catch VBScript Virtual Keyboard WPF bulk copy code contactus delegates dynamically page create generate script jQuery Audio Plugins jQuery Mobile jQuery Video Plugins jqGridview scroll top/bottom of div slider from folder tree viewhttps://youtu.be/-C1oCshJZKs