May 16, 2011 at 1:51 pm
Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
I just created a database and trying to insert a name and info and I am getting the above message as an error.
I am new to this and am not sure if I even did it correctly.
Thank you
May 16, 2011 at 1:55 pm
For someone to assist you, they will need more information... post the create table statement, your T-SQL statement that is having the problem and the sample data that is giving you the problem.
As a wild guess, which has a great probability of being wrong I would venture that the name column is defined as say Char(10) and you are attempting to insert more than 10 characters in that column. Then again and more than likely I could be incorrect.
So help those who want to help you ....
May 16, 2011 at 2:17 pm
That is alright I corrected the problem. Thank you.:-)
May 16, 2011 at 2:46 pm
dlmagers (5/16/2011)
That is alright I corrected the problem. Thank you.:-)
How did you correct the problem?
My guess is that you did what Ron suggested.
Please post the problem and the steps that you took to resolve it.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 16, 2011 at 3:57 pm
my client number needed to have (5) characters and my address needed to be longer.
May 16, 2011 at 4:03 pm
dlmagers (5/16/2011)
Msg 8152, Level 16, State 14, Line 1String or binary data would be truncated.
bitbucket-25253 (5/16/2011)
I would venture that the name column is defined as say Char(10) and you are attempting to insert more than 10 characters in that column.
So Ron was correct and he told you exactly what the problem was.
Give credit where credit is deserved.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 17, 2011 at 12:17 am
Thank you Ron. I appreciate your help.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply