从数据库中读取一篇文章有三千个汉字,这样全显示在一个页面上太长了,所以我想要页面只显示一千个汉字该怎么分页啊???

create proc pro_note
@rowIndex int ,
@maxNumber int
 as
with page as
(select id,row_number() over(order by id) as rowindex from note)

  select note.* from note,page where note.id=page.id
 and page.rowindex between (@rowIndex+1) and (@rowIndex+@maxNumber)