insertint prob

• Subu

  Say Hey Kid

  Points: 680

  More actions

  November 5, 2007 at 10:54 pm

  #180925

  Hi

  create table countries3

  (

  country_id char(10) not null,

  countr_name varchar(23),

  region_id int)

  insert into countries2 values('ca','canada',2)

  i am inserting data into this table i am getting blow error any boyd help me

  Msg 8152, Level 16, State 14, Line 1

  String or binary data would be truncated.

  The statement has been terminated.

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 5, 2007 at 11:06 pm

  #748510

  You're creating table Countries3, but inserting into countries2. Is that a typo?

  Are there any triggers on the table?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Subu

  Say Hey Kid

  Points: 680

  More actions

  November 5, 2007 at 11:47 pm

  #748520

  yes thanku u r right bye