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
SQLServer 数据分栏
原创
©著作权归作者所有:来自51CTO博客作者CYQ0520的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
java 监听 sqlserver 数据库的变化
java 监听 sqlserver 数据库的变化
Server SQL Java -
css 分栏布局 columns
分栏布局 – 简介将子元素拆分为列,使用场景并不多,重点掌握 columns
css html html5 php 默认值