摘要:        
订单号格式:yyyyMMddhhmmxxxx,后面四位递增数createproc [dbo].[proc_OrderManager](@userId uniqueidentifier,@creditCount int)asbeginbegin trandeclare @nowCount intdeclare @now nvarchar(12)declare @date datetimeselect @date=GETDATE()select @now= CONVERT(nvarchar(12),@date,112)+DATENAME(HH,@date)+DATENAME(MINUTE,@dat    
阅读全文