ppendTerms
AS INSERT INTO dbo.tblSearchTerms
(DateData, TimeData, IP, Page, SearchTermData,
Port, UserData, IP2, Browser, HTTPCode, Col012,
Col013, Type)
SELECT CAST(DateData AS DateTime), TimeData, IP, Page, SearchTermData,
Port, UserData, IP2, Browser, HTTPCode, Col012, Col013, Type
FROM dbo.tblLogItems
WHERE (Type LIKE 'POST') AND (NOT (UserData LIKE '-')) AND (NOT (SearchTermData LIKE '-'))
GO
存储过程 #4： sp_UpdateSearchTermData
下面的存储过程用于 DTS 软件包中，它清除最近添加到 tblSearchTerms 表中的搜索项。
CREATE PROCEDURE dbo.sp_UpdateSearchTermData
AS UPDATE dbo.tblSearchTerms
SET SearchTermData = REPLACE(SUBSTRING(SearchTermData, 64,
PATINDEX('%+Search+Server+Name%', SearchTer页码：[1] [2] [3] [4] [5] [6] [7] [8] [9] 第6页、共9页 |
