SQLserver判断一小时内是否存在同样记录，存在则修改，不存在则新增

1. 表结构：

  2、

--新增浏览记录、职位
	IF @type='Insert_BrowseRecordInfoPosition'
	BEGIN
		--企业ID
		SET @EnterpriseID= ISNULL((SELECT TOP 1 EnterpriseID FROM dbo.BS_Position WHERE PositionID=@PositionID AND IsDelete=0),0)
		--判断一小时内是否存在浏览过同条件的记录
		IF (SELECT COUNT(1) FROM dbo.BR_BrowseRecord WHERE UserID=@UserID AND EnterpriseID=@EnterpriseID
			AND BrowseTypeID=2 AND SourceTypeID=1 AND PositionID = @PositionID
			AND CreateTime> DATEADD(HOUR,-1,GETDATE()))>0
		BEGIN
			UPDATE dbo.BR_BrowseRecord SET CreateTime=GETDATE()
			WHERE UserID=@UserID AND EnterpriseID=@EnterpriseID
			AND BrowseTypeID=2 AND SourceTypeID=1  AND PositionID = @PositionID
			AND CreateTime> DATEADD(HOUR,-1,GETDATE())
			SELECT @@ROWCOUNT
		END
		ELSE 
		BEGIN
			INSERT INTO dbo.BR_BrowseRecord
					( UserID ,
					  EnterpriseID ,
					  PositionID,
					  BrowseTypeID,
					  SourceTypeID,
					  IsRead ,
					  IsDelete ,
					  CreateTime
					)
			VALUES  ( @UserID , -- UserID - int
					  @EnterpriseID , -- EnterpriseID - int
					  @PositionID,
					  2,
					  1,
					  0 , -- IsRead - bit
					  0 , -- IsDelete - bit
					  GETDATE()  -- CreateTime - datetime
					)
			SELECT @@IDENTITY
		END
		
	END