spAdd_ClientSites

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@Name	nvarchar(255)	IN
@DefaultTemplateID	int	IN
@DefaultPageID	int	IN
@Deleted	bit	IN
@ClientsID	int	IN
@Guid	uniqueidentifier	IN
@OwnerID	int	IN

Definition

Copy


                CREATE   PROCEDURE dbo.spAdd_ClientSites
(
        @PKID        int output,
        @CurrentUsersID    int,        
    @Name            nvarchar(255),
    @DefaultTemplateID    int,
    @DefaultPageID        int,
    @Deleted        bit,
    @ClientsID        int,
    @Guid            uniqueidentifier,
    @OwnerID        int
)
AS

INSERT INTO ClientSites
(
    Name            ,
    DefaultTemplateID    ,
    DefaultPageID        ,
    Deleted        ,
    ClientsID        ,
    Guid            ,
    OwnerID        
)

VALUES
(
    @Name            ,
    @DefaultTemplateID    ,
    @DefaultPageID        ,
    @Deleted        ,
    @ClientsID        ,
    @Guid            ,
    @OwnerID        
)

SELECT
    @PKID = @@Identity