文件名称：数据库上机试验-屏蔽敏感词汇的代码
文件大小：1KB
文件格式：TXT
更新时间：2013-11-06 11:31:53
要求屏蔽敏感词汇
屏蔽敏感词汇的数据库代码 insert into BBSTopic (TNumber,TSID,TUID,TReplyCount,TEmotion,TTopic,TContents,TTime,TClickCount,TFlag,TLastClickT) values ('1-'+Convert(varchar(4),DATEPART(YYYY,GETDATE()))+Convert(varchar(2),DATEPART(DD,GETDATE()))+'_'+Convert(Varchar(4),RIGHT(RAND(DATEPART(MS,GETDATE())*1000),4)),1,2,1,1,'BUY USC','20/20/10 USC,30.5IST.....','2005-7-13',0,1,'2005-7-13 14:21:2') UPDATE BBSUsers SET UPoint = UPoint +10 WHERE UID = 2 UPDATE BBSSection SET STopicCount = STopicCount +1 WHERE SID = 1