String or binary data would be truncated

Question

I am trying to execute the following SQL query using MS SQL Server Management Studio express.

 Insert INTO SU_PRO_RE ( d_id, fis_year, last_dp, budget_amt)  VALUES ( 'A','2011', 0, 205000.00);

Everything looks correct to me but every time i try to execute it it has the following:

String or binary data would be truncated.
The statement has been terminated.

(0 row(s) affected)

The tables as set as follows:

d_id        = char(1) *PK*
fis_year    = char(2) *PK*
last_dp     = smallint
budget_amt  = money

I'm not sure what i am doing incorrect but i'm sure i am just over looking something very obvious so any help would be great! :)

Thanks, David

Joe Stefanelli · Accepted Answer · 2011-02-21 20:01:23Z

9

fis_year is defined as char(2) but you're trying to insert a 4 character value of '2011'.

answered Feb 21, 2011 at 20:01

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

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

3 Comments

@Lamak: Great minds think alike. Not sure how that explains my mind though. :-)

Yep that was it, Joe. I knew it had to be something small like that. Guess i was just over-thinking it too much. :o) Thanks!

well, thanks for the compliment....i'm not sure if anything can explain your mind ;-)

Lamak · Accepted Answer · 2011-02-21 20:01:58Z

2

Well, the field fis_year is defined as CHAR(2), and you are trying to insert a value that has 4 charachters long.

answered Feb 21, 2011 at 20:01

Lamak

70.8k12 gold badges118 silver badges119 bronze badges

Thanks for your reply as well, Lamak! :o)