sqlserver2005中的万能分页存储过程。建立主表临时表 create table #temp(rownumber bigint,orderseqno varchar(36),goodsname varchar(50),companyname varchar(100))建立子表临 时表create table #detail(orderseqno varchar(36),detailid uniqueidentifie
sqlserver2005中的万能分页存储过程。–建立主表临时表
create table #temp(rownumber bigint,orderseqno varchar(36),goodsname varchar(50),companyname varchar(100))–建立子表临 时表create table #detail(orderseqno varchar(36),detailid uniqueidentifier,unitprice decimal(12,2),qty int)–插入主表数据到主表临时表insert into #tempselect oo.rownumber, oo.orderseqno, oo.goodsname, oo.companyname from(select row_number () over (order by oi.createdate desc) as rownumber,oi.orderseqno, oi.goodsname ,ci.companynamefrom orderinfo oi inner join companyinfo ci on oi.companyid=ci.companyidwhere oi.createdate