数据库
linyizhong001
蔺宜忠,1983,日语、国际贸易双学位,偶尔看看编程,喜欢,从事软件开发
展开
-
数据库 分页功能
with temptbl as( select ROW_NUMBER() over(order by id desc) as 行号,* from news)select * from temptbl where 行号 between @startIndex and @endIndex原创 2010-04-15 20:10:00 · 262 阅读 · 0 评论 -
分页,数据库分页功能 SqlServer
SELECT * from ( select *,ROW_NUMBER() over(order by id desc) as rowno from news) as mytable where rowno between 5 and 7原创 2010-05-04 19:42:00 · 254 阅读 · 0 评论 -
存储过程
<br />USE [YuLinEducation_DB]<br />GO<br />/****** Object: StoredProcedure [dbo].[usp_MakerLookTeacherInfoPage] Script Date: 07/25/2010 12:19:20 ******/<br />SET ANSI_NULLS ON<br />GO<br />SET QUOTED_IDENTIFIER ON<br />GO<br />-- ======================原创 2010-07-25 18:41:00 · 243 阅读 · 0 评论