//统计始章节和书籍的字数
update chapter set fontCount=len(cast(content as varchar(8000)));
update book set finishCount=pp.fontCount from book inner join ( select sum(fontCount) as
fontCount,c.bookid as bookid from chapter c,book b where c.bookid=b.bookid group by c.bookid )as
pp on book.bookid= pp.bookid ;