疑难问题
求教单号争用问题（重复键）
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区DECLARE @i VARCHAR(14)--取最大单号避免重复
SELECT @i=MAX(cast(EEA001 as decimal(18,0)))+cast( floor(rand()*100) as int) FROM dbo.RMSEEA
--主表
insert into RMSEEA (EEA001,EEA004,EEA002,EEA003,EEA005,EEA006,EEA007,EEA008,EEA009,EEA010,EEA011,EEA012,EEA013,EEA014,EEA015,EEA016,EEA017,EEA018,EEA019,EEA020,EEA027,EEA028,EEA029,EEA030,EEA031,EEA032,EEA033, EEA034,EEA035,EEA036,EEA902,EEA037,EEA038,EEA039) values (@i,'51','20110609','1011','002','101','767','990003','','','','',1.0000,5000.0000,5000.0000,0.0000,0.0000,0.0000,0.0000,5000.0000,@i,0.0000,0.0000,0.0000,0.0000,'','','',0.0000,0.0000,'2011-06-09 09:30:29:510',0.0000,0,0)
--主表
--明细表
DECLARE @k INT --循环次数
DECLARE @j VARCHAR(10)--明细单号
SET @k=0
WHILE @k<100
BEGIN
SET @k=@k+1
SET @j=RIGHT('000' + CAST(@k AS varchar(10)),3) --明细单号补零
select EEB001,EEB002,EEB003,EEB004,EEB005,EEB006,EEB007,EEB008,EEB009,EEB010,EEB011,EEB012,EEB013,EEB020,EEB021,EEB022,EEB023 from RMSEEB
insert into RMSEEB (EEB001,EEB002,EEB003,EEB004,EEB005,EEB006,EEB007,EEB008,EEB009,EEB010,EEB011,EEB012,EEB013,EEB020,EEB021,EEB022,EEB023) values (@i,@j,'00002','','','件',1.0000,'********************',5000.0000,1.0000,5000.0000,'F','F','',0.0000,'','51')
END[/code]
SELECT @i=MAX(cast(EEA001 as decimal(18,0)))+cast( floor(rand()*100) as int) FROM dbo.RMSEEA
--主表
insert into RMSEEA (EEA001,EEA004,EEA002,EEA003,EEA005,EEA006,EEA007,EEA008,EEA009,EEA010,EEA011,EEA012,EEA013,EEA014,EEA015,EEA016,EEA017,EEA018,EEA019,EEA020,EEA027,EEA028,EEA029,EEA030,EEA031,EEA032,EEA033, EEA034,EEA035,EEA036,EEA902,EEA037,EEA038,EEA039) values (@i,'51','20110609','1011','002','101','767','990003','','','','',1.0000,5000.0000,5000.0000,0.0000,0.0000,0.0000,0.0000,5000.0000,@i,0.0000,0.0000,0.0000,0.0000,'','','',0.0000,0.0000,'2011-06-09 09:30:29:510',0.0000,0,0)
--主表
--明细表
DECLARE @k INT --循环次数
DECLARE @j VARCHAR(10)--明细单号
SET @k=0
WHILE @k<100
BEGIN
SET @k=@k+1
SET @j=RIGHT('000' + CAST(@k AS varchar(10)),3) --明细单号补零
select EEB001,EEB002,EEB003,EEB004,EEB005,EEB006,EEB007,EEB008,EEB009,EEB010,EEB011,EEB012,EEB013,EEB020,EEB021,EEB022,EEB023 from RMSEEB
insert into RMSEEB (EEB001,EEB002,EEB003,EEB004,EEB005,EEB006,EEB007,EEB008,EEB009,EEB010,EEB011,EEB012,EEB013,EEB020,EEB021,EEB022,EEB023) values (@i,@j,'00002','','','件',1.0000,'********************',5000.0000,1.0000,5000.0000,'F','F','',0.0000,'','51')
END[/code]
...全文
相关推荐
银联订单号永远不会重复的生成算法分析与示例
银联订单号永远不会重复的生成算法分析与示例。 主要讲解了java的生成算法，其他语言原理也是一样。
商城小程序订单号重复，如何解决这种bug？？
🏆本文收录于《CSDN问答解惑-专业版》专栏，主要记录项目实战过程中的Bug之前因后果及提供真实有效的解决方案，希望能够助你一臂之力，帮你早日登顶实现财富自由🚀；同时，欢迎大家关注&&收藏&&订阅！持续更新中，up！up！up！！
C#生成唯一不重复订单号
本文给大家介绍的是使用C#生成唯一不重复订单号的方法，主要用到了lock锁，有需要的小伙伴可以参考下。
线上订单号重复了？一招搞定它！
问题的背景 公司老的系统原先采用的时间戳生成订单号，导致了如下情形 打断一下：大家知道怎么查系统某项重复的数据吧 SELECT * FROM XX表 WHERE 重复项 in( SELECT 重复项 FROM XX表 GROUP BY 重复项 HAVING count(1) >= 2) 解决方法 不得了，这样重复岂不是一单成功三方回调导致另一单也成功了。 多个服务怎么保证生成的订单号唯一呢？ 先上code package com.zhongjian.util; public class IdWorkerUtil{ private long workerId; private
c#后台生成不重复的订单号及后台存储过程
SQL,C#,不重复编码，订单号 1. C#后台封装方法 通用获取最大单据编号, 可以生成以下3个类型的单号 CG1603-000001 CG201603-000001 CG20160321-000001
