I want to insert multiple rows in a table using sql server 2005

Question

I am wanting to insert rows into a four column table. I have inserted rows in the first two columns. However, when I try adding to the third and fourth column I receive the following error,

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

I am using the following query:

USE DB
GO
INSERT INTO dbo.Table (Column1, Column2, Column3,Column4)
VALUES ('data','data','data','data')

FireFox · Accepted Answer · 2012-07-18 02:36:49Z

1

Check if one of your strings exceeds the length of the datafield. For example, if you are inserting a string of length 50 into a varchar(20), you would recieve this error.

answered Jul 18, 2012 at 2:36

FireFox

4702 gold badges4 silver badges14 bronze badges

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

1 Comment

Caleb Tharp Over a year ago

Thanks. I increased the column size and that resolved the issue.

Robert · Accepted Answer · 2012-07-18 02:36:51Z

1

You are receiving that error because your columns are not capable of storing a value that large. You need to either shorten the length of your strings being inserted or increased the length on the column structure.

answered Jul 18, 2012 at 2:36

Robert

8,7672 gold badges29 silver badges34 bronze badges

1 Comment

Caleb Tharp Over a year ago

Thanks for your help. I increased the length on the column structure and that resolved the error.

Collectives™ on Stack Overflow

I want to insert multiple rows in a table using sql server 2005

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related