摘要：1.select*from ( select row_number()over(orderby tempColumn)tempRowNumber,*from (selecttop 开始位置+10 tempColumn=0,*from Table1)t )tt where tempRowNumber>开始位置2.selecttop10*from Table1 where Id>(selectmax(Id) from (selecttop 开始位置 Id from Table1order by Id)tt)3.selecttop10*from Table1 where Id notin 阅读全文

摘要：1.在查询结果中显示列名： a.用as关键字：select name as '姓名' from students order by age b.直接表示：select name '姓名' from students order by age 2.精确查找: a.用in限定范围：select * from students where native in ('湖南', '四川') b.between...and：select * from students where age between 20 and 30 c.“=”：sele 阅读全文

摘要：1.新建一个word文档,然后把你想要显示的布局在word文档上布局好,然后另存为xx.html;2.以word打开方式打开xx.html,点击视图,选择页面视图,然后保存!3.打开xx.html,同样用打开word的方式打开,然后选择页面视图,然后在里面随便修改一点,我自己是弄个空格然后点保存4.后台代码: Response.ContentEncoding = System.Text.Encoding.UTF8; Response.ClearContent(); Response.ClearHeaders(); Respons... 阅读全文