| ÞÓã ÇáÇÓÆáÉ æ ÇáÇÓÊÝÓÇÑÇÊ áÚãá ÇáÓíÑÝÑÇÊ ÇáÎÇÕÉ [ ÞÓã ÎÇÕ áÃÓÆáÉ æÇÓÊÝÓÇÑÇÊ Úãá ÇáÓíÑÝÑÇÊ ÇáÎÇÕÉ ] [ íÑÌì ÇáÇáÊÒÇã ÈÞæÇäíä ÞÓã ÇáÃÓÆáÉ æÇáÇÓÊÝÓÇÑÇÊ ] |
 |
|
|
ÃÏæÇÊ ÇáãæÖæÚ | ÇäæÇÚ ÚÑÖ ÇáãæÖæÚ |
05-09-2012, 04:41 AM
|
#1 | ||||||||||
 
|
ÇäÇ ÇáÓíÑÝÑ ÈÊÇÚí d11 ÚÇíÒ ÇÎáíå d13 ÈäÝÓ Çá db íÇ ÑíÊ ÍÏ íÑÏ |
||||||||||
|
| ÅÚáÇäÇÊ google |
|
|
|
05-09-2012, 10:53 AM
|
#2 | ||||||||||
  
|
ÇÊÝÖá íÇ ÈÇÔÇ ßæÏ ÈáÛÉ HTML:
UPDATE [dbo].[_RefObjCommon] SET Service = 1 WHERE CodeName128 like '%ITEM_EU%' UPDATE [dbo].[_RefObjCommon] SET Service = 1 WHERE CodeName128 like '%ITEM_CH%' UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 8994 AND 9005 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9008 AND 9025 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9028 AND 9045 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9048 AND 9065 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9068 AND 9085 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9088 AND 9105 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9114 AND 9125 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9134 AND 9145 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9154 AND 9225 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID = 38620 ÍÊáÇÞí ÇáÏÇÊÇ ÝíåÇ ÏÌÑí 12 æ 13 æØÈÚÇ ÇáßáíäÊ ÇäÊÇ ÍÊÊÓÑÝ Ýíå ãáÍæÙå : ÇáÏÇÊÇ ÓÄÇÁ ÏÌÑí 11 Çæ 12 Çæ 13 Çæ 20 ãÔ ÍÊÃËÑ Ú ÇáÓíÑÝÑ ÊÇäí ÍÇÌå ÇÖÇÝÉ Çá 120 Level Skill In Database ßæÏ ÈáÛÉ HTML:
UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 1 AND 273 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 276 AND 3481 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 3486 AND 3491 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 3493 AND 8321 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 8328 AND 8328 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 8331 AND 12176 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12178 AND 12186 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12188 AND 12196 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12198 AND 12199 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12201 AND 12206 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12210 AND 12216 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12218 AND 12222 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12225 AND 12306 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 12323 AND 20309 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 20311 AND 20501 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 20503 AND 21266 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 21268 AND 29693 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 29696 AND 30897 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31038 AND 31086 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31088 AND 31103 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31105 AND 31181 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31190 AND 31196 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 31198 AND 31924 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32088 AND 32874 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32891 AND 32894 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 32897 AND 32904 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33042 AND 33045 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33072 AND 33073 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33072 AND 33073 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33077 AND 33287 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33289 AND 33294 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33296 AND 33300 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33302 AND 33307 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33309 AND 33312 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33314 AND 33338 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33340 AND 33347 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33349 AND 33372 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33374 AND 33382 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 33740 AND 33785 UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 7182 AND 7184 UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 3436 AND 3440 UPDATE dbo._RefSkill SET Service = 0 WHERE ID BETWEEN 5409 AND 5409 |
||||||||||
|
|
|
| íÊÕÝÍ ÇáãæÖæÚ ÍÇáíÇð : 1 (0 ÚÖæ æ 1 ÒÇÆÑ) | |
|
|
.gif){kind=icon}
ÇáÚÑÖ ÇáÚÇÏí
