I am facing problem during insert this value in table

• dsachu

  SSCrazy

  Points: 2242

  More actions

  September 16, 2011 at 8:36 am

  #243290

  Dear All,

  I am facing problem during insert this value in table abc

  where table field name is "class" which size is varchar(max)

  i want add below content in this field, but facing below problem kindly help me........

  "Class 35 in respect of Consultation in the fields of staffing, recruiting, employee retention and workforce and talent management; business consultation."

  this query doesnt work and I get this error message

  Msg 8152, Level 16, State 14, Line 1

  String or binary data would be truncated.

  The statement has been terminated.

  Regards,

  Sachin

• Nils Gustav Stråbø

  SSChampion

  Points: 11259

  More actions

  September 16, 2011 at 9:56 am

  #1382646

  Impossible to say what is causing it before you post the INSERT statement and table DDL.

  Are there by any chance one or more triggers on that table? Perhaps it's a trigger that is trowing this error.