摘要: 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 阅读全文
posted @ 2011-05-10 12:26 思维的边疆 阅读(662) 评论(0) 推荐(0) 编辑
摘要: 实现数字月份到英文月份缩写的转换,调换一下位置就可以倒转过来,同样可以实现各种映射。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 阅读全文
posted @ 2011-05-10 12:17 思维的边疆 阅读(3426) 评论(0) 推荐(0) 编辑