1 ------------------------------------ 2 --用途:查询列表,返回前几条或者全部 3 --项目名称: 4 --说明: 5 --时间:2012/8/15 12:16:41 6 ------------------------------------ 7 ALTER PROCEDURE [dbo].[GetTopList_Pro] 8 @tbname varchar(30), 9 @cols varchar(400), 10 @top int=0, 11 @strWhere varchar(1000)='', 12 @orderby varchar(1000)='' 13 AS 14 declare @strTop varchar(30)='' 15 if @strWhere!='' 16 set @strWhere=N' where '+ @strWhere 17 18 if @orderby!='' 19 set @orderby=N' order by '+ @orderby 20 21 if @cols='' 22 set @cols=N' * ' 23 24 if @top>0 25 set @strTop=N' top '+ convert(varchar,@top) 26 27 /* SET NOCOUNT ON */ 28 exec(N'select ' 29 +N' '+@strTop 30 +N' '+@cols 31 +N' from '+@tbname 32 +N' '+@strWhere 33 +N' '+@orderby) 34 35 36 print N'select ' 37 +N' '+@strTop 38 +N' '+@cols 39 +N' from '+@tbname 40 +N' '+@strWhere 41 +N' '+@orderby 42 RETURN