摘要：
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGO/** create by huang qing* modify by chaoxueling* modify date 2013-05-15*/ALTER PROCEDURE [dbo].[sp_GetPropsTop_ByPropsCount]@PageIndexint,@PageSizeint,@OrderTypeintASBEGINif(@OrderType=1)beginwith Mem_TbUserPropsTop as(select A.*,b.PropsCountB,ROW_NUMBER() 阅读全文
