String or binary data would be truncated.\r\nThe statement has been terminated. while xml insertion

Question

Can you please let me know how do I resolve this problem while inserting xml data into Sql Server 2008

ex = {"String or binary data would be truncated.\r\nThe statement has been terminated."}

I already replaced ', "" with an empty string

thanks in Advance

ysrb · Accepted Answer · 2011-04-04 07:00:08Z

26

Please check the datetype of the column. Make sure it has enough space.

answered Apr 4, 2011 at 7:00

ysrb

6,7202 gold badges32 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Charlie Over a year ago

How to know which column is causing the problem

JiBéDoublevé · Accepted Answer · 2015-05-19 13:32:16Z

20

Check the Database Column Size and Data length. you will get this error when you are storing data of length greater than that of defined size.

    Ex. string Data = "saving this data causes error.";
    int datalength = Data.Length;  // will be 30 characters , greater than defined size

    Customer.Name = Data;
    //you will get error for this line if you have Name (varchar 25, null) in db      .

edited May 19, 2015 at 13:32

JiBéDoublevé

4,2944 gold badges41 silver badges61 bronze badges

answered Aug 30, 2012 at 14:20

sudhansu63

6,2204 gold badges41 silver badges55 bronze badges

Comments

Hal · Accepted Answer · 2012-01-23 19:35:07Z

1

If you're using a subquery change the = between the sub query and main query to in.

It may be that you have more than one field for each record of the main query.

edited Jan 23, 2012 at 19:35

Hal

1,0091 gold badge11 silver badges22 bronze badges

answered May 29, 2011 at 9:47

Mohsen

4,3069 gold badges45 silver badges77 bronze badges

Collectives™ on Stack Overflow

String or binary data would be truncated.\r\nThe statement has been terminated. while xml insertion

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related