spClone_SiteProfilePhotoForm

Parameters

Parameter	Parameter Type	Mode
@PKCloneID	int	IN
@PKCloneFromID	int	IN
@CurrentUsersID	int	IN

Definition

Copy


CREATE PROCEDURE [dbo].[spClone_SiteProfilePhotoForm]
(
    @PKCloneID        int,
    @PKCloneFromID  int,
    @CurrentUsersID int
)

AS


INSERT INTO SiteProfilePhotoForm
(
      ContentId,
      CaptionEditable, 
      DefaultCaption,
      PhotoEditable,
      ApprovalRequired,
      ThumbSize, 
      CategoryFolderID,
      AfterUpdatePageID,
      LargeSize,
      TAGCODEID
)
select
    @PKCloneID,
      CaptionEditable, 
      DefaultCaption,
      PhotoEditable,
      ApprovalRequired,
      ThumbSize, 
      CategoryFolderID,
      AfterUpdatePageID,
      LargeSize,
      TAGCODEID

from SiteProfilePhotoForm where [contentID] = @PKCloneFromID