开屏1.0 2.0批量替换店号SQL

admin

-- 1. 更新 记录绑定 表
UPDATE [lj_kp].[dbo].[记录绑定]
SET 范围组ID = 115
WHERE
    设备ID IN (
'10948','10272','10935','10339','11303','10410','11365','10569','100322','10110019',
'10110016','70725','11166','10832','11076','10963','120701','11137','11459','10163',
'10121','11173','11388','10314','11559','10411','10942','10277','10098','50029',
'50028','10673','10497','11493','10599','100323','151279','10110008','10110001',
'10110020','70539','30782','31551','91562','10136'
    )
    AND 范围组ID = 0;


-- 2. 批量更新 NEW_KP 表
UPDATE [lj_kp].[dbo].[NEW_KP]
SET
    特殊门店 = 1,   
    当前资源 = 'http://kb.ljcvs.com:11520/update/scr/ljcs20260402.zip'
WHERE
    店号 IN (
'10948','10272','10935','10339','11303','10410','11365','10569','100322','10110019',
'10110016','70725','11166','10832','11076','10963','120701','11137','11459','10163',
'10121','11173','11388','10314','11559','10411','10942','10277','10098','50029',
'50028','10673','10497','11493','10599','100323','151279','10110008','10110001',
'10110020','70539','30782','31551','91562','10136'
    )
    AND 特殊门店 = 0 and 是否强制角度 = 0;