/*
姓名：邢捷
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 '%找死%')
第四章上机.rar （13个子文件） 
第四章上机 BBSDataBase 
阶段1.sql 881B BBS.mdf 10MB BBS_log.ldf 1024KB 第四章阶段1.sql 629B 第四章阶段4.sql 1KB 第四章作业2.sql 1KB 第四章作业1.sql 786B 阶段2.sql 334B 第四章阶段2.sql 605B 阶段3.sql 768B 阶段4.sql 498B 第四章阶段3.sql 555B 阶段5.sql 238B资源评论
