摘要: 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 ' 阅读全文
posted @ 2010-12-07 17:04 Curitis 阅读(210) 评论(0) 推荐(0) 编辑