用fastreport来打印richedit里面的内容。刚开始放一个frxrichview组件到报表上,然后在 var str: TMemoryStream; begin begin str:= TMemoryStream.Create; CurrRichRecord.richedit.Lines.SaveToStream(str); str.Posit
先来定义分页语句将要用到的几个参数: int currentPage ; //当前页 int pageRecord ; //每页显示记录数 以之前的ADDRESSBOOK数据表为例(每页显示10条记录): 一、SqlServer下载 分页语句 String sql = "select top "+pageRecord +" * from addressbook where id not i
分别用 NOT IN 和 NOT EXISTS 实现: NOT IN: select TOP 10 * FROM student WHERE id not in (SELECT TOP (2*10) id FROM student) NOT EXISTS: SELECT TOP (10) * FROM student AS s1 WHERE NOT EXISTS (SELEC
原生SQL语句,实现SQL Server分页查询 DECLARE @pageCount INT DECLARE @pageIndex INT SET @pageCount = 10 -- #{page.pageSize}SET @pageIndex = 2 -- #{page.pageNum};WITH ACTE AS (SELECTROW_NUMBER () OVER (ORDER B