String or binary data would be truncated

While inserting row in SQL Server, whenever you encounter such error then you need to re-verify whether or not you are exceeding any column value

for example in your sql table you have defined length of other_name as char(12)
create table users
(
code integer identity(1,1) primary key,
username varchar(32) not null unique,
other_number char(12) not null
)

and if your insert statement is as follows
insert into users (username,other_number) values('admin','1234567890123');

 only then this error will come i.e String or binary data would be truncated

 which means you are exceeding length check of column named other_name therefore reducing it will insert row successfully like below.

insert into users (username,other_number) values('admin','123456789012');

Comments

Post a Comment

Popular posts from this blog

storing byte array as column value in datatable using c#

This post covers following objective 1. How to declare and define datatable 2. Add columns at runtime 3. Add column to store byte array (image/file etc) //YOUR PHOTOGRAPH HERE MemoryStream ms = new MemoryStream(); argPhotograph.Save(ms, System.Drawing.Imaging.ImageFormat.Gif); //DECLARING DATATABLE DataTable dt = new DataTable ();   dt . Columns . Add ( "ID" ); dt . Columns . Add ( "Name" ); dt . Columns . Add ( "CreatedOn" , typeof ( DateTime )); dt . Columns . Add ( "Photograph" , typeof ( byte []));   //METHOD 1: ADDING DATA DataRow row = null; row = dt.NewRow(); row[ "ID"] = 1; row[ "Name"] = "Usman"; row[ "CreatedOn"] = DateTime.Now; row[ "Photograph"] = argPhotograph.ToArray(); dt.Rows.Add(row);  //METHOD 2: ADDING DATA dt.Row.Add( 1, "Usman", DateTime.Now, argPhotograph.ToArray());
Read more

post form data and bind with model : using jquery ajax in mvc

There are multiple ways of posting data from view to controller using jquery + ajax in mvc 1. post data by assigning parameters one by one and bind it with model manually 2. post data by serializing form and automatically binding with model 3. post data by assigning parameters one by one + making custom class and assigning data to its variables which are named similarly as that of model Method 1:     $.ajax({         url: "/Controller/SubmitAction",         type: "POST",         dataType: "text",         data: { name: _name, age: _age, id: _id },         success: function (response) {             alert("Success");         },         error: function () {             alert("Error");         }     }); public JsonResult Sub...
Read more

Htc sensation XL mobile not working with windows 7 or above, along with Htc sync software

Problem: Htc sensation XL connectivity issue with windows 7 or above + Htc sensation XL device detection issue with Android Studio + Htc sensation XL connectivity issue with Htc sync software Solution: For all of the above mentioned issues, please see steps below for smooth & successful activity. Please make sure that 1. In Pc, Htc sync software version 3.2.26 or 3.3.63 is installed. 2. Ur device is connected to PC via usb cable. 3. In mobile, change connectivity options from 'charging' to 'htc sync' 4. In Pc, goto device manager and see for hardware changes in order to see whether device is detected by Pc or not yet, If yes you are good to go, if not follow below mentioned steps 5. Run htc sync in compatible mode by going to properties and changing OS to windows vista, then re-run Htc sync software and re-connect from mobile to see if it detects changes or not, if yes we are good to go but if not see below 6. In Pc, install htc usb drivers fro...
Read more