摘要：1dropprocedureset_rank;2createprocedureset_rank()3begin4set@i=1;5set@number=(selectcount(1)fromsuppliers_performance);6updatesuppliers_performancesetscore_rank=0;78while@i<@number9do10begin11updatesuppliers_performancesetscore_rank=@iwhereidin(selectidfrom(selectidfromsuppliers_performancewheresc 阅读全文