Question

存储过程中sql语句拼接

elect top 10 *from 飞狐工作室 where 员工编号 not in(select max(员工编号) from (select top 30 员工编号 from 飞狐工作室 order by 员工编号) as 员工)set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[mypager]
@pagerindex int=1,
@pagesize int=10,
@rowcount int output
as
select @rowcount=count(*) from 飞狐工作室 --计算记录数
declare @start int
declare @end int
set @start=((@pagerindex-1)* @pagesize)+1 --计算起始行号
set @end=(@start+@pagesize)-1 --计算结束行号
declare @sql nvarchar(300)
set @sql=？exec(@sql)

Answer 1

'select top '+@pagesize +' * from 飞狐工作室 where 员工编号 not in (select max(员工编号) from (select top '+ @start +' 员工编号 from 飞狐工作室 order by 员工编号) as 员工)'