以下代码请在SQL查询分析器中执行【先执行下面这个，请按顺序执行①】
-------------------------复制开始，本段不复制-----------------------
UPDATE main_db_1.dbo.NpcDropItemParams2
SET
Pro01 = 5000, Pro02 = 5000, Pro03 = 450, Pro04 = 2900, Pro05 = 500, Pro06 = 1900, Pro07 = 3200,
Pro08 = 45000, Pro09 = 5000, Pro10 = 5000, Pro11 = 2500, Pro12 = 2500, Pro13 = 1900, Pro14 = 3200,
Pro15 = 2500, Pro16 = 2500, Pro17 = 5000, Pro18 = 3200, Pro19 = 3200, Pro20 = 2500, Pro21 = 2500,
Pro22 = 2200, Pro23 = 2300, Pro24 = 45000, Pro25 = 2500, Pro26 = 2500, Pro27 = 2500, Pro28 = 2500,
Pro29 = 2500, Pro30 = 2500, Pro31 = 2500, Pro32 = 2500, Pro33 = 2500, Pro34 = 2500, Pro35 = 2500,
Pro36 = 2500, Pro37 = 2500, Pro38 = 2500, Pro39 = 2500, Pro40 = 2500, Pro41 = 2500, Pro42 = 2500,
Pro43 = 2500, Pro44 = 2500, Pro45 = 2500, Pro46 = 2500, Pro47 = 2500, Pro48 = 2500 WHERE (Pro01 = 5000) AND (Pro02 = 5000) AND (Pro03 = 5000) AND (Pro04 = 5000) AND
(Pro05 = 5000) AND (Pro06 = 5000) AND (Pro08 = 5000) AND (Pro07 = 5000) AND
(Pro10 = 5000) AND (Pro09 = 5000) AND (Pro11 = 5000) AND (Pro12 = 5000) AND
(Pro13 = 5000) AND (Pro14 = 5000) AND (Pro15 = 5000) AND (Pro16 = 5000) AND
(Pro17 = 5000) AND (Pro18 = 5000) AND (Pro19 = 5000) AND (Pro20 = 5000) AND
(Pro21 = 5000) AND (Pro22 = 5000) AND (Pro23 = 5000) AND (Pro24 = 5000) AND
(Pro25 = 5000) AND (Pro27 = 5000) AND (Pro26 = 5000) AND (Pro28 = 5000) AND
(Pro29 = 5000) AND (Pro30 = 5000) AND (Pro31 = 5000) AND (Pro32 = 5000) AND
(Pro33 = 5000) AND (Pro34 = 5000) AND (Pro35 = 5000) AND (Pro36 = 5000) AND
(Pro37 = 5000) AND (Pro38 = 5000) AND (Pro39 = 5000) AND (Pro40 = 5000) AND
(Pro41 = 5000) AND (Pro42 = 5000) AND (Pro43 = 5000) AND (Pro44 = 5000) AND
(Pro45 = 5000) AND (Pro46 = 5000) AND (Pro47 = 5000) AND (Pro48 = 5000)
-------------------------------复制完毕，本段不复制-----------------------
【在执行下面这个，请按顺序执行②】
-------------------------------复制开始，本段不复制-----------------------
update MAIN_DB_1.dbo.NpcDropItemParams2
SET
Pro01 = 46000 WHERE
(ItemId01 BETWEEN 27145 and 27147) or
(ItemId01 BETWEEN 27401 and 27403) or
(ItemId01 BETWEEN 28672 and 28759) or
(ItemId01 BETWEEN 28761 and 29027) or
(ItemId01 BETWEEN 29069 and 29074) or
(ItemId01 BETWEEN 29077 and 29088) or
(ItemId01 BETWEEN 29155 and 29167) or
(ItemId01 BETWEEN 29212 and 29219) or
(ItemId01 BETWEEN 29221 and 29223) or
(ItemId01 BETWEEN 24717 and 24739) or
(ItemId01=24709) or (ItemId01=29172) or (ItemId01=29061) or (ItemId01=29063) update MAIN_DB_1.dbo.NpcDropItemParams2
SET
Pro02 = 46000 WHERE
(ItemId02 BETWEEN 27145 and 27147) or
(ItemId02 BETWEEN 27401 and 27403) or
(ItemId02 BETWEEN 28672 and 28759) or
(ItemId02 BETWEEN 28761 and 29027) or
(ItemId02 BETWEEN 29069 and 29074) or
(ItemId02 BETWEEN 29077 and 29088) or
(ItemId02 BETWEEN 29155 and 29167) or
(ItemId02 BETWEEN 29212 and 29219) or
(ItemId02 BETWEEN 29221 and 29223) or
(ItemId02 BETWEEN 24717 and 24739) or
(ItemId02=24709) or (ItemId02=29172) or (ItemId02=29061) or (ItemId02=29063) update MAIN_DB_1.dbo.NpcDropItemParams2
SET
Pro03 = 46000 WHERE
(ItemId03 BETWEEN 27145 and 27147) or
(ItemId03 BETWEEN 27401 and 27403) or
(ItemId03 BETWEEN 28672 and 28759) or
(ItemId03 BETWEEN 28761 and 29027) or
(ItemId03 BETWEEN 29069 and 29074) or
(ItemId03 BETWEEN 29077 and 29088) or
(ItemId03 BETWEEN 29155 and 29167) or
(ItemId03 BETWEEN 29212 and 29219) or
(ItemId03 BETWEEN 29221 and 29223) or
(ItemId03 BETWEEN 24717 and 24739) or
(ItemId03=24709) or (ItemId03=29172) or (ItemId03=29061) or (ItemId03=29063) update MAIN_DB_1.dbo.NpcDropItemParams2
SET
Pro07 = 46000 WHERE
(ItemId07 BETWEEN 27145 and 27147) or
(ItemId07 BETWEEN 27401 and 27403) or
(ItemId07 BETWEEN 28672 and 28759) or
(ItemId07 BETWEEN 28761 and 29027) or
(ItemId07 BETWEEN 29069 and 29074) or
(ItemId07 BETWEEN 29077 and 29088) or
(ItemId07 BETWEEN 29155 and 29167) or
(ItemId07 BETWEEN 29212 and 29219) or
(ItemId07 BETWEEN 29221 and 29223) or
(ItemId07 BETWEEN 24717 and 24739) or
(ItemId07=24709) or (ItemId07=29172) or (ItemId07=29061) or (ItemId07=29063) update MAIN_DB_1.dbo.NpcDropItemParams2
SET
Pro09 = 46000 WHERE
(ItemId09 BETWEEN 27145 and 27147) or
(ItemId09 BETWEEN 27401 and 27403) or
(ItemId09 BETWEEN 28672 and 28759) or
(ItemId09 BETWEEN 28761 and 29027) or
(ItemId09 BETWEEN 29069 and 29074) or
(ItemId09 BETWEEN 29077 and 29088) or
(ItemId09 BETWEEN 29155 and 29167) or
(ItemId09 BETWEEN 29212 and 29219) or
(ItemId09 BETWEEN 29221 and 29223) or
(ItemId09 BETWEEN 24717 and 24739) or
(ItemId09=24709) or (ItemId09=29172) or (ItemId09=29061) or (ItemId09=29063)
-------------------------复制结束，本段不复制------------
-------------------------修改完成------------------------
-------------------------复制开始，本段不复制-----------------------
UPDATE main_db_1.dbo.NpcDropItemParams2
SET
Pro01 = 5000, Pro02 = 5000, Pro03 = 450, Pro04 = 2900, Pro05 = 500, Pro06 = 1900, Pro07 = 3200,
Pro08 = 45000, Pro09 = 5000, Pro10 = 5000, Pro11 = 2500, Pro12 = 2500, Pro13 = 1900, Pro14 = 3200,
Pro15 = 2500, Pro16 = 2500, Pro17 = 5000, Pro18 = 3200, Pro19 = 3200, Pro20 = 2500, Pro21 = 2500,
Pro22 = 2200, Pro23 = 2300, Pro24 = 45000, Pro25 = 2500, Pro26 = 2500, Pro27 = 2500, Pro28 = 2500,
Pro29 = 2500, Pro30 = 2500, Pro31 = 2500, Pro32 = 2500, Pro33 = 2500, Pro34 = 2500, Pro35 = 2500,
Pro36 = 2500, Pro37 = 2500, Pro38 = 2500, Pro39 = 2500, Pro40 = 2500, Pro41 = 2500, Pro42 = 2500,
Pro43 = 2500, Pro44 = 2500, Pro45 = 2500, Pro46 = 2500, Pro47 = 2500, Pro48 = 2500 WHERE (Pro01 = 5000) AND (Pro02 = 5000) AND (Pro03 = 5000) AND (Pro04 = 5000) AND
(Pro05 = 5000) AND (Pro06 = 5000) AND (Pro08 = 5000) AND (Pro07 = 5000) AND
(Pro10 = 5000) AND (Pro09 = 5000) AND (Pro11 = 5000) AND (Pro12 = 5000) AND
(Pro13 = 5000) AND (Pro14 = 5000) AND (Pro15 = 5000) AND (Pro16 = 5000) AND
(Pro17 = 5000) AND (Pro18 = 5000) AND (Pro19 = 5000) AND (Pro20 = 5000) AND
(Pro21 = 5000) AND (Pro22 = 5000) AND (Pro23 = 5000) AND (Pro24 = 5000) AND
(Pro25 = 5000) AND (Pro27 = 5000) AND (Pro26 = 5000) AND (Pro28 = 5000) AND
(Pro29 = 5000) AND (Pro30 = 5000) AND (Pro31 = 5000) AND (Pro32 = 5000) AND
(Pro33 = 5000) AND (Pro34 = 5000) AND (Pro35 = 5000) AND (Pro36 = 5000) AND
(Pro37 = 5000) AND (Pro38 = 5000) AND (Pro39 = 5000) AND (Pro40 = 5000) AND
(Pro41 = 5000) AND (Pro42 = 5000) AND (Pro43 = 5000) AND (Pro44 = 5000) AND
(Pro45 = 5000) AND (Pro46 = 5000) AND (Pro47 = 5000) AND (Pro48 = 5000)
-------------------------------复制完毕，本段不复制-----------------------
【在执行下面这个，请按顺序执行②】
-------------------------------复制开始，本段不复制-----------------------
update MAIN_DB_1.dbo.NpcDropItemParams2
SET
Pro01 = 46000 WHERE
(ItemId01 BETWEEN 27145 and 27147) or
(ItemId01 BETWEEN 27401 and 27403) or
(ItemId01 BETWEEN 28672 and 28759) or
(ItemId01 BETWEEN 28761 and 29027) or
(ItemId01 BETWEEN 29069 and 29074) or
(ItemId01 BETWEEN 29077 and 29088) or
(ItemId01 BETWEEN 29155 and 29167) or
(ItemId01 BETWEEN 29212 and 29219) or
(ItemId01 BETWEEN 29221 and 29223) or
(ItemId01 BETWEEN 24717 and 24739) or
(ItemId01=24709) or (ItemId01=29172) or (ItemId01=29061) or (ItemId01=29063) update MAIN_DB_1.dbo.NpcDropItemParams2
SET
Pro02 = 46000 WHERE
(ItemId02 BETWEEN 27145 and 27147) or
(ItemId02 BETWEEN 27401 and 27403) or
(ItemId02 BETWEEN 28672 and 28759) or
(ItemId02 BETWEEN 28761 and 29027) or
(ItemId02 BETWEEN 29069 and 29074) or
(ItemId02 BETWEEN 29077 and 29088) or
(ItemId02 BETWEEN 29155 and 29167) or
(ItemId02 BETWEEN 29212 and 29219) or
(ItemId02 BETWEEN 29221 and 29223) or
(ItemId02 BETWEEN 24717 and 24739) or
(ItemId02=24709) or (ItemId02=29172) or (ItemId02=29061) or (ItemId02=29063) update MAIN_DB_1.dbo.NpcDropItemParams2
SET
Pro03 = 46000 WHERE
(ItemId03 BETWEEN 27145 and 27147) or
(ItemId03 BETWEEN 27401 and 27403) or
(ItemId03 BETWEEN 28672 and 28759) or
(ItemId03 BETWEEN 28761 and 29027) or
(ItemId03 BETWEEN 29069 and 29074) or
(ItemId03 BETWEEN 29077 and 29088) or
(ItemId03 BETWEEN 29155 and 29167) or
(ItemId03 BETWEEN 29212 and 29219) or
(ItemId03 BETWEEN 29221 and 29223) or
(ItemId03 BETWEEN 24717 and 24739) or
(ItemId03=24709) or (ItemId03=29172) or (ItemId03=29061) or (ItemId03=29063) update MAIN_DB_1.dbo.NpcDropItemParams2
SET
Pro07 = 46000 WHERE
(ItemId07 BETWEEN 27145 and 27147) or
(ItemId07 BETWEEN 27401 and 27403) or
(ItemId07 BETWEEN 28672 and 28759) or
(ItemId07 BETWEEN 28761 and 29027) or
(ItemId07 BETWEEN 29069 and 29074) or
(ItemId07 BETWEEN 29077 and 29088) or
(ItemId07 BETWEEN 29155 and 29167) or
(ItemId07 BETWEEN 29212 and 29219) or
(ItemId07 BETWEEN 29221 and 29223) or
(ItemId07 BETWEEN 24717 and 24739) or
(ItemId07=24709) or (ItemId07=29172) or (ItemId07=29061) or (ItemId07=29063) update MAIN_DB_1.dbo.NpcDropItemParams2
SET
Pro09 = 46000 WHERE
(ItemId09 BETWEEN 27145 and 27147) or
(ItemId09 BETWEEN 27401 and 27403) or
(ItemId09 BETWEEN 28672 and 28759) or
(ItemId09 BETWEEN 28761 and 29027) or
(ItemId09 BETWEEN 29069 and 29074) or
(ItemId09 BETWEEN 29077 and 29088) or
(ItemId09 BETWEEN 29155 and 29167) or
(ItemId09 BETWEEN 29212 and 29219) or
(ItemId09 BETWEEN 29221 and 29223) or
(ItemId09 BETWEEN 24717 and 24739) or
(ItemId09=24709) or (ItemId09=29172) or (ItemId09=29061) or (ItemId09=29063)
-------------------------复制结束，本段不复制------------
-------------------------修改完成------------------------
