USE SRO_VT_SHARD
GO
update _RefScrapOfPackageItem set OptLevel = 7 where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_%_0%_A'
update _RefScrapOfPackageItem set Variance = 1073741823 where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_%_0%_A'
update _RefScrapOfPackageItem set MagParamNum = 2 where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_%_0%_A'
update _RefScrapOfPackageItem set MagParam1 = 30064771144 where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_%_0%_A'
update _RefScrapOfPackageItem set MagParam2 = 30064771150 where RefPackageItemCodeName like 'PACKAGE_ITEM_EU_%_0%_A'
update _RefScrapOfPackageItem set OptLevel = 7 where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_%_0%_A'
update _RefScrapOfPackageItem set Variance = 1073741823 where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_%_0%_A'
update _RefScrapOfPackageItem set MagParamNum = 2 where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_%_0%_A'
update _RefScrapOfPackageItem set MagParam1 = 30064771144 where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_%_0%_A'
update _RefScrapOfPackageItem set MagParam2 = 30064771150 where RefPackageItemCodeName like 'PACKAGE_ITEM_CH_%_0%_A'
bu Queryi kendine göre düzenleyerek yapabilirsin, OptLevel kısmı +, kodun sonunda ki 0% yazan yer ise Dg ayarı. bu arada sadece str int 7 vermekte.