كويرى تعديل نسبة البلس شغال تمام

الكود:

USE [SRO_VT_SHARD] /*** This query to data base dr 13 www.egyptsro.com ****/


DECLARE @Param2 INT , @Param3 INT , @Param4 INT , @Param22 INT , @Param33 INT , @Param44 INT

/*** normal poweder ****/
SET @Param2=1 /*** replace nomber"1" as u want ****/
SET @Param3=1 /*** replace nomber"1" as u want ****/
SET @Param4=1 /*** replace nomber"1" as u want ****/
/*** magic poweder ****/
SET @Param22=1 /*** replace nomber"1" as u want ****/
SET @Param33=1 /*** replace nomber"1" as u want ****/
SET @Param44=1 /*** replace nomber"1" as u want ****/

UPDATE dbo._RefObjItem SET Param2=(@Param2) WHERE ID BETWEEN '2033' AND '2044'
UPDATE dbo._RefObjItem SET Param3=(@Param3) WHERE ID BETWEEN '2033' AND '2044'
UPDATE dbo._RefObjItem SET Param4=(@Param4) WHERE ID BETWEEN '2033' AND '2044'
UPDATE dbo._RefObjItem SET Param2=(@Param2) WHERE ID = '21375'
UPDATE dbo._RefObjItem SET Param3=(@Param3) WHERE ID = '21375'
UPDATE dbo._RefObjItem SET Param4=(@Param4) WHERE ID = '21375'
UPDATE dbo._RefObjItem SET Param2=(@Param22) WHERE ID BETWEEN '2045' AND '2056'
UPDATE dbo._RefObjItem SET Param3=(@Param33) WHERE ID BETWEEN '2045' AND '2056'
UPDATE dbo._RefObjItem SET Param4=(@Param44) WHERE ID BETWEEN '2045' AND '2056'
UPDATE dbo._RefObjItem SET Param2=(@Param22) WHERE ID = '21404'
UPDATE dbo._RefObjItem SET Param3=(@Param33) WHERE ID = '21404'
UPDATE dbo._RefObjItem SET Param4=(@Param44) WHERE ID = '21404'


data base egyptsro d13 cap 120

Alchemy Rate Egyptsro.com