sql server - VARCHAR(MAX) Issue: String or binary data would be truncated -


my problem

string or binary data truncated.

i tried researching on error , still doesn't solve problem. checked declarations , varchar(max)

  disable trigger membership.member_id_emergency_contact_tr_critical_change_log on membership.member_id_emergency_contact;   disable trigger membership.member_images_tru on membership.member_images;   disable trigger membership.member_other_info_tru_critical_change_log on membership.member_other_info;   disable trigger membership.member_tr_critical_change_log on membership.[member];  declare @field varchar(max),         @new_value varchar(max)  declare crit_loop cursor      select mccl.field, mccl.new_value membership.member_critical_change_log mccl mccl.member_code = 'mem-ho-2015-0000026'  open crit_loop fetch crit_loop @field, @new_value  while @@fetch_status = 0  begin     exec [membership].[commitcriticalchanges] @field, @new_value,'mem-ho-2015-0000026'; fetch crit_loop @field, @new_value end  close crit_loop deallocate crit_loop   ;enable trigger membership.member_id_emergency_contact_tr_critical_change_log on membership.member_id_emergency_contact;   enable trigger membership.member_images_tru on membership.member_images;   enable trigger membership.member_other_info_tru_critical_change_log on membership.member_other_info;   enable trigger membership.member_tr_critical_change_log on membership.[member] 

commit critical procedure

create procedure membership.commitcriticalchanges     @field varchar(max),     @new_value varchar(max),     @member_code varchar(255) begin  if @field = 'signature'   update membership.member_images set signature = @new_value    member_code = @member_code  else if @field = 'photo'   update membership.member_images set photo = @new_value member_code = @member_code  end 

hoping answer soon. thanks!


Comments

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -