摘要:
create procedure Page@tablename varchar(50),@primarykey varchar(50),@pageindex int,@pagesize int,@where varchar(1000)as declare @strsql varchar(5000); begin if(@where='') begin set @strsql='select top '+cast(@pagesize as varchar(50))+' * from '+@tablename+' where '+@primarykey+' not in (select top ' 阅读全文