北大青鸟ACCP5.0第一学期SQL Server课程第四章上机阶段+作业源代码

/* 姓名：邢捷 2008年9月4日 第四章上机阶段4 */ ------------------------------------------------------------------- --主贴表过滤词 ------------------------------------------------------------------- update BBSTopic set TTopic=replace(replace(TTopic,'共产党','*'),'找死','*'), TContents=replace(replace(TContents,'共产党','*'),'找死','*') ------------------------------------------------------------------- --跟贴表过滤词 ------------------------------------------------------------------- update BBSReply set RTopic = replace(replace(RTopic,'共产党','*'),'找死','*'), RContents = replace(replace(RContents,'共产党','*'),'找死','*') ------------------------------------------------------------------- --主贴表锁贴 ------------------------------------------------------------------- USE BBS UPDATE BBSUsers SET UState = 8 WHERE UID IN(SELECT TUID FROM BBSTopic WHERE TContents like '%共产党%' or TContents like '%找死%') OR UID IN(SELECT TUID FROM BBSTopic WHERE TTopic LIKE '%共产党%' OR TTopic LIKE '%找死%') ------------------------------------------------------------------- --跟贴表锁贴 ------------------------------------------------------------------- UPDATE BBSUsers SET UState=8 WHERE UID IN(SELECT RUID FROM BBSReply WHERE RTopic LIKE '%共产党%' OR RTopic LIKE '%找死%') OR uid IN(SELECT RUID FROM BBSReply WHERE RContents LIKE '%共产党%' OR RContents LIKE '%找死%')