Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

sql, when i running the below SQL command i receieved the following error

Posted on 2011-10-05
1
Medium Priority
?
225 Views
Last Modified: 2012-08-14
run:
insert into customer (code, name, addr1, city, state, zip, phone1, phone2, fax1, contact1, user1, salesrep1, terms, shipvia, active, pricelevel, user4, userid, user_date, country, factored, duplicate_po, default_wh, memo_code, box_mode, currency, autoprint ) values ('STEELS', 'STEELS ', '601 Jacksonville Warehouse 506 Bealls Blvd.', 'Jacksonville', 'TX', '75766', '713-6675601', '713-6675601', '', 'ROBIN COX', 'CIT', 'RK', 'N45', '', '1', 'A', 'A', 'NIR', '2011-10-05', '',  'Y', 'Y', '00', 'CIT', '0', 'USD', 'N')

error:

Server: Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.

please advice
0
Comment
Question by:gvilbis
1 Comment
 
LVL 46

Accepted Solution

by:
Kent Olsen earned 2000 total points
ID: 36920179
Hi gvilbis,

I suspect that one of your strings is longer than the column definition.  Make sure that all of the VARCHAR objects are large enough to contain the entire string that you need to store.


Kent
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question