08 2009 档案

一个生成订单流水号的存储过程
摘要：createprocedure sp_order_BuildCode@ordercode varchar(10) outputasbeginset @ordercode=''select @ordercode = max(substring(code,6,4)) from ys_orderwhere Datediff(day ,addtime,getdate())=0if(@ordercode i... 阅读全文
posted @ 2009-08-04 19:46 阿多米 阅读(360) 评论(0) 推荐(0)