spAddUpdate_TargetedContentChecks

Parameters

Parameter	Parameter Type	Mode
@TargetedPartID	int	IN
@PartOrder	int	IN
@ContentID	int	IN

Definition

Copy



        CREATE PROCEDURE [dbo].[spAddUpdate_TargetedContentChecks] (
            @TargetedPartID int,
            @PartOrder int,
            @ContentID int
        )

        as

        if exists(select ContentID from TargetedContentChecks where TargetedPartID=@TargetedPartID and PartOrder=@PartOrder)
        begin
            update TargetedContentChecks set ContentID=@ContentID
            where TargetedPartID=@TargetedPartID and PartOrder=@PartOrder
        end
        else
        begin
            insert into TargetedContentChecks(TargetedPartID, PartOrder, ContentID) values (@TargetedPartID, @PartOrder, @ContentID)
        end