SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create procedure [dbo].[p_act_actors_change_internal_reference]
	@actor_id int,
	@internal_reference ais_code_medium,
	@sequence_code ais_code_short = '%'
as 
	update act_actors
	set act_internal_reference = @internal_reference,
		act_sequence_code =	case 
								when @sequence_code = '%' then act_sequence_code
								else @sequence_code
							end
	where act_actor_id = @actor_id 









GO
