2021-03-30

最新推荐文章于 2022-03-16 10:36:59 发布

「已注销」

最新推荐文章于 2022-03-16 10:36:59 发布

阅读量113

点赞数

分类专栏： SqlServer

本文链接：https://blog.csdn.net/m0_50623581/article/details/115316213

版权

SqlServer 专栏收录该内容

6 篇文章 0 订阅

订阅专栏


UPDATE mfsyscserial WITH(ROWLOCK)
        set 
        sysserialno=a.sysserialno+'-RW' +convert(varchar(10),b.NUM),
        cserialno =a.cserialno + '-RW' + CONVERT(VARCHAR, (SELECT count (*) from mfsyscserial WHERE cserialno like ('ACM042T08D' + '-RW%'))),
        lasteditby = 'wangjp',
		lasteditdt = GETDATE()
        from mfsyscserial a
        inner join (select  ROW_NUMBER() OVER (ORDER BY sysserialno) AS NUM,
                            sysserialno,
                            cserialno,
                            lasteditdt 
                    FROM mfsyscserial 
                    WHERE sysserialno='ACM042T08D' and partno='407344-001' ) b
        on a.sysserialno=b.sysserialno
            and a.cserialno=b.cserialno
            and a.lasteditdt=b.lasteditdt
 
UPDATE mfsyscserial WITH(ROWLOCK)
    SET sysserialno = sysserialno + '-RW'
                        + CONVERT(VARCHAR, (SELECT Count (*) FROM mfsyscserial WHERE sysserialno LIKE ('ACM042T08D' + '-RW%'))),
						cserialno = cserialno + '-RW'
                        + CONVERT(VARCHAR, (SELECT Count (*) FROM mfsyscserial WHERE cserialno LIKE ('ACM042T08D' + '-RW%'))),
						lasteditby = 'wangjp',
						lasteditdt = Getdate()
    WHERE sysserialno = 'ACM042T08D'
    AND partno = '407344-001'