create table clients(Clientid int, Clientname varchar(30), Contactperson varchar(20), Contactnumber nvarchar(30), Emailid nvarchar(50), Address varchar(100), Clientagency varchar(30), Issuedate datetime, Payment nvarchar(30))
insert into Clients values(00001, 'Timesjob.com', 'Boopathiraja and Madhu', '9841050214 and 985632410', 'rajesh_sep09@yahoo.co.in', 'No 10 govindan st Ayyavoo colony Aminjikarai ch-29',null, null, 'Rs.28080')
on execution gives the following statement:
String or binary data would be truncated.
The statement has been terminated.
what can i do?
2006-07-24 21:52:54 · 3 answers · asked by Rajesh K 2 in Computers & Internet ➔ Programming & Design
you have to make sure what are the length of the fields in the data base table.
like i noticed Contactperson field have the length of 20, and the value you inserted have the length of 25 so this field has been truncated. So suggestions: either you make the field bigger or you cut your value that you want to insert in that field.
2006-07-24 21:58:05 · answer #1 · answered by darksoulcrawling 3 · 0⤊ 0⤋
Maybe give a hint to the question in the question title. That'd be a good start.
Rawlyn.
2006-07-24 22:27:27 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Answer to your problem
http://search.msn.co.uk/results.aspx?q=meaning+String+or+binary+data+would+be+truncated&geovar=56&FORM=REDIR
2006-07-24 23:28:40 · answer #3 · answered by Joe_Young 6 · 0⤊ 0⤋