spAddUpdate_Search

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@SearchTypeId	int	IN
@SiteContentId	int	IN
@ContentUpdateDate	datetime	IN
@ExtendedKey	nvarchar(255)	IN
@Title	nvarchar(255)	IN
@SearchText	ntext	IN
@TagText	ntext	IN
@SearchDate1	datetime	IN
@SearchDate2	datetime	IN
@SearchInt1	int	IN

Definition

Copy



  CREATE    PROCEDURE [dbo].[spAddUpdate_Search]
  (
  @PKID int output,
  @SearchTypeId int,
  @SiteContentId int,
  @ContentUpdateDate datetime,
  @ExtendedKey nvarchar(255),
  @Title nvarchar(255),
  @SearchText ntext,
  @TagText ntext,
  @SearchDate1 datetime,
  @SearchDate2 datetime,
  @SearchInt1 int
  )
  AS
  BEGIN TRANSACTION

  SELECT @PKID = [ID]
  FROM Search
  WHERE SiteContentID = @SiteContentID
  AND ExtendedKey = @ExtendedKey

  IF (@PKID<=0)
  BEGIN
  INSERT INTO Search
  (
  SearchTypeId,
  SiteContentId,
  ContentUpdateDate,
  ExtendedKey,
  Title,
  SearchText,
  TagText,
  SearchDate1,
  SearchDate2,
  SearchInt1
  )
  VALUES
  (
  @SearchTypeId,
  @SiteContentId,
  @ContentUpdateDate,
  @ExtendedKey,
  @Title,
  @SearchText,
  @TagText,
  @SearchDate1,
  @SearchDate2,
  @SearchInt1
  )
  SELECT @PKID = @@Identity
  END
  ELSE
  BEGIN
  UPDATE Search SET
  SearchTypeId = @SearchTypeId,
  SiteContentId = @SiteContentId,
  ContentUpdateDate = @ContentUpdateDate,
  ExtendedKey = @ExtendedKey,
  Title = @Title,
  SearchText= @SearchText,
  TagText = @TagText,
  SearchDate1 = @SearchDate1,
  SearchDate2 = @SearchDate2,
  SearchInt1 = @SearchInt1
  WHERE [ID]=@PKID
  END
  COMMIT TRANSACTION