spAddUpdate_VanityURL

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@RealmTypeID	int	IN
@RealmID	int	IN
@ClientUserID	int	IN
@PageID	int	IN
@TabID	int	IN
@VanityURL	nvarchar(255)	IN
@TargetURL	nvarchar(max)	IN
@ClientSitesID	int	IN

Definition

Copy



    CREATE PROCEDURE [dbo].[spAddUpdate_VanityURL]
    (
    @PKID int output,
    @RealmTypeID int ,
    @RealmID int ,
    @ClientUserID int ,
    @PageID int ,
    @TabID int ,
    @VanityURL [nvarchar] (255),
    @TargetURL nvarchar (max),
    @ClientSitesID int

    )
    AS
    BEGIN
    IF (@PKID<=0)
      BEGIN
      INSERT INTO [VanityURL]
      (
      RealmTypeID,
      RealmID,
      ClientUserID,
      PageID,
      TabID,
      VanityURL,
      TargetURL,
      ClientSitesID
      )
      VALUES
      (
      @RealmTypeID,
      @RealmID,
      @ClientUserID,
      @PageID,
      @TabID,
      @VanityURL,
      @TargetURL,
      @ClientSitesID
      )

      SELECT @PKID = @@Identity

      END
      ELSE

      UPDATE [VanityURL] SET
      RealmTypeID=@RealmTypeID,
      RealmID=@RealmID,
      ClientUserID =@ClientUserID,
      PageID=@PageID,
      TabID=@TabID,
      VanityURL=@VanityURL,
      TargetURL=@TargetURL,
      ClientSitesID =@ClientSitesID
      WHERE [ID]=@PKID

      END