一些正则表达式,MS也就采集文章时会有用。。
INSERT INTO blog_Article ( log_Url, log_CateID, log_AuthorID, log_Level, log_ID, log_Title, log_Intro, log_Content, log_PostTime, log_CommNums, log_ViewNums, log_TrackBackNums, log_IsTop )
SELECT Sd_Info.Htmlname, 1 AS 表达式1, 1 AS 表达式2, 4 AS 表达式3, Sd_Info.ID, Sd_Info.Title, Sd_Info.Content, Sd_Info.Content, Sd_Info.AddDate, 0 AS 表达式4, 0 AS 表达式5, 0 AS 表达式6, 0 AS 表达式7
FROM Sd_Info;


