数据库语句一录

 

Declare @MaxBookID bigint
Declare @MaxChapterID bigint
Declare Cur Cursor For
Select Max(BookID),Max(ChapterID) From Novel_Chapter_LocalTmp  where SITEID=10 GROUP BY BOOKID
Open Cur
Fetch next From Cur Into @MaxBookID,@MaxChapterID
While @@fetch_status=0    
Begin
    DELETE FROM Novel_Chapter_LocalTmp WHERE State=1 AND ChapterUrl<>'' AND BookID=@MaxBookID AND ChapterID<@MaxChapterID
    Fetch Next From Cur Into @MaxBookID,@MaxChapterID
End  
Close Cur  
Deallocate Cur

 

用于清理章节表中垃圾章节信息