SQLServer数据分栏

CREATE PROCEDURE [dbo].[dxd_mx]
         @dxd_id   VARCHAR(120)=''
AS
BEGIN
--set nocount on
declare @sql1 nVARCHAR(4000)
SET @sql1='select * from (SELECT ROW_NUMBER() OVER(ORDER BY t1.n ASC) AS m1,* from (SELECT  ROW_NUMBER() OVER(ORDER BY id DESC) AS n, ID,dxd_id, yqs,yhs,guanghao FROM lxcy_dxd_mx_v WHERE dxd_id='''+@dxd_id+''' or dxd_id='''') t1 WHERE n<=30)tt1
LEFT JOIN
(SELECT ROW_NUMBER() OVER(ORDER BY t2.n ASC) AS m2,* from (SELECT  ROW_NUMBER() OVER(ORDER BY id DESC) AS n, ID,dxd_id, yqs,yhs,guanghao FROM lxcy_dxd_mx_v WHERE dxd_id='''+@dxd_id+''' or dxd_id='''') t2 WHERE n BETWEEN 31 AND 60)tt2
on m1=m2'
EXEC sp_executesql @sql1
RETURN
END

创新互联公司主营溧水网站建设的网络公司,主营网站建设方案,成都app软件开发,溧水h5成都微信小程序搭建,溧水网站营销推广欢迎溧水等地区企业咨询

文章标题：SQLServer数据分栏
文章出自：http://www.kmzsk.com/article/pegcde.html