摘要：
1CREATE PROCEDURE HVC_Statistics_Sta 2( 3 @week int 4) 5 6AS 7 set nocount on 8 9 if not exists(select * from HVC_Statistics_PortalRank where week= @week)10 begin11 insert into HVC_Statist... 阅读全文
2006年6月27日 #
摘要：
CREATE PROCEDURE HVC_Statistics_GetPortalRankByWeek( @Week int, @Rownum int, @SortField int ) ASDECLARE @SQL VARCHAR(1000) SET @SQL = 'SELECT TOP ' +CAST(@Rownum AS VARCHAR(20))+' PortalName=(Select ... 阅读全文