摘要:
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 阅读全文
摘要:
实现数字月份到英文月份缩写的转换,调换一下位置就可以倒转过来,同样可以实现各种映射。class month_convert { private $Month_E = array(1 => "Jan", 2 => "Feb", 3 => "Mar", 4 => "Apr", 5 => "May", 6 => "Jun", 7 => "Jul", 8 => "Aug", 9 => &qu 阅读全文