spClone_SiteLayouts

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@NewName	nvarchar(510)	IN
@NewGuid	uniqueidentifier	IN

Definition

Copy




      CREATE   procedure dbo.spClone_SiteLayouts
      (
            @PKID        int OUTPUT,
            @CurrentUsersID int,
            @NewName    nvarchar(510),
            @NewGuid        uniqueidentifier
      )

      as

      insert into dbo.SiteLayouts ( 
          Guid,
          ClientSitesID,
          Name,
          Description,
          Content,
          StyleSheet,
        StyleSheetID,
          OwnerID,
          DocType 
      )select               
          @NewGuid,
          ClientSitesID,    
          @NewName,     
          Description,
          Content,
          StyleSheet,
          StyleSheetID,
        @CurrentUsersID,
          DocType
      from        
          SiteLayouts
      where       
          ID = @PKID;


      select  @PKID = @@Identity

      exec spAuditThis @CurrentUsersID, 1, @NewGuid, 3