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,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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!