spClone_QuickSearchPart

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CloneContentID	int	IN
@ClonedContentID	int	IN
@CurrentUsersID	int	IN

Definition

Copy



CREATE  Procedure dbo.spClone_QuickSearchPart
(
@PKID int output,
@CloneContentID int,
@ClonedContentID int,
@CurrentUsersID int
)
as

DECLARE @NewGuid uniqueidentifier
SET @NewGuid = NEWID()

    Insert into QuickSearchPart
        (SiteContentID,
         Name,
         SearchCaption,
         DestinationPageID,
         Guid
        )
     Select @CloneContentID, 
        Name,
        SearchCaption,
        DestinationPageID,
        @NewGuid
     From QuickSearchPart
     Where SiteContentiD = @ClonedContentID

SELECT @PKID = @@Identity

exec spAuditThis @CurrentUsersID, 1, @NewGuid, 1