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
Post a Comment