随机更新具有不同名称的表的列记录 [英] Update columns records of table with different names randomly
问题描述
嗨专家,
您能否帮助我完成以下要求,我们是否可以创建一个程序或一个小代码来更新所有 5474条记录 (列资源名称 - 分支 。 cfg 。 xml)
< g class =" gr_ gr_25 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace"数据-GR-ID =" 25" ID = QUOT; 25"> deptrans< / g取代;表。
嗨Kenny
请提供样本数据,表结构从下次获得一些快速答案
试试这个
DECLARE @Deptrans TABLE(ID INT IDENTITY(1,1) ),
名称VARCHAR(50)
);
DECLARE @logic TABLE(ID INT,
NewNames VARCHAR(50)
);
INSERT INTO @Deptrans(Names)
SELECT'Cranch.cfg.xml'union all
SELECT'Cranc.cfg.xml'union all
SELECT'Cranc.cfg.xml'union所有
SELECT'Cranc.cfg.xml'union所有
SELECT'Cranch.cfg.xml'union all
SELECT'Cranch.cfg.xml 'union all
SELECT'Cranch.cfg.xml'union all
SELECT'Cranch.cfg.xml'union all
SELECT'Cranch.cfg.xml'union all
SELECT 'Branch.cfg.xml'union所有
SELECT'Cranc.cfg.xml'
INSERT INTO @Logic(ID,NewNames)
SELECT 0,' Bank1_CIBC_Branch.cfg.xml'union all
SELECT 1,'Commercial_CIBCEXT.cfg.xml'union all
SELECT 2,'Bank1_PCF_Mobile.cfg.xml'union all
SELECT 3,'Bank1_CIBC_Mobile。 cfg.xml'
select * from @Deptrans
;使用Setss
AS
(SELECT ID%4 ROWN,*
FROM @Deptrans)
UPDATE ss
SET Names = lo.NewNames
FROM Setss ss
JOIN @logic lo on ss.ROWN = lo.ID
SELECT * FROM @Deptrans
Hi Experts,
Could you help me with the below requirement, can we create a procedure or a small code to update all the 5474 records (column resource name - Branch.cfg.xml) of the <g class="gr_ gr_25 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="25" id="25">deptrans</g> table.
Hi Kenny
Please provide sample data, table structure from next time for wining some quick answers
Try this
DECLARE @Deptrans TABLE ( ID INT IDENTITY(1,1), Names VARCHAR(50) ); DECLARE @logic TABLE (ID INT, NewNames VARCHAR(50) ); INSERT INTO @Deptrans (Names) SELECT 'Branch.cfg.xml' union all SELECT 'Branch.cfg.xml' union all SELECT 'Branch.cfg.xml' union all SELECT 'Branch.cfg.xml' union all SELECT 'Branch.cfg.xml' union all SELECT 'Branch.cfg.xml' union all SELECT 'Branch.cfg.xml' union all SELECT 'Branch.cfg.xml' union all SELECT 'Branch.cfg.xml' union all SELECT 'Branch.cfg.xml' union all SELECT 'Branch.cfg.xml' INSERT INTO @Logic (ID, NewNames) SELECT 0, 'Bank1_CIBC_Branch.cfg.xml' union all SELECT 1, 'Commercial_CIBCEXT.cfg.xml' union all SELECT 2, 'Bank1_PCF_Mobile.cfg.xml' union all SELECT 3, 'Bank1_CIBC_Mobile.cfg.xml' select * from @Deptrans ;With Setss AS (SELECT ID%4 ROWN, * FROM @Deptrans) UPDATE ss SET Names = lo.NewNames FROM Setss ss JOIN @logic lo on ss.ROWN = lo.ID SELECT * FROM @Deptrans
这篇关于随机更新具有不同名称的表的列记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!