摘要:
ALTERPROCEDURE[dbo].[PublishYearly_Delete]@in_YearlyIDVARCHAR(500)ASBEGINUPDATEPublishYearlySETStatus=2WHERECHARINDEX(','+CAST(YearlyIDASVARCHAR(100))+',',@in_YearlyID)>0ENDALTERPROCEDURE[dbo].[PublishYearly_GetList]@request_page_numINT,--基于0的,如第一页@page_size=0@page_sizeINT,@YearIN 阅读全文