![]() |
|
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
![]() |
|
أدوات الموضوع | انواع عرض الموضوع |
![]() |
#1 | ||||||||||
![]() ![]()
|
اولا انا اسف اني اتخنات معا مروان المشرف و بقولو انا اسف ثانين الموضوع واضح جدا بس كده |
||||||||||
![]() |
![]() |
#2 | ||||||||||||
![]() ![]()
|
ولا يهمك عادى والله بس طريقة كلامك هى اللى زعلتنى .. والمشكلة اللى عندك ديه انا مش فاهم قصدك والله .. :(( |
||||||||||||
![]() |
![]() |
#3 | ||||||||||||
![]() ![]()
|
[CENTER]120 Level Skill In Database حتفتح New Query وتضيف ال حاجات دي كود:
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 حتنزل الملف ده
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] وبعدين تحطه ف C:\ واستخدم ال Query ده كود:
DELETE FROM [SRO_VT_SHARD ].[dbo].[Tab_RefNest] USE [SRO_VT_SHARD] GO BULK INSERT Tab_RefNest FROM 'C:\RefNEst.txt' WITH (FIELDTERMINATOR = '\t') شغااااااااااااااااااااااااااااااااال ![]() |
||||||||||||
التعديل الأخير تم بواسطة محمد سعييد ; 05-09-2012 الساعة 01:20 AM
![]() |
![]() |
#4 | ||||||||||
![]() ![]()
|
انا عاوز اعمل ادد لي اسكلات الوحوش بتاعت الجبتر انا لما اقف جنبها مبتدربنيش و عاوز اخلي ماكس اسكل 120 بس كده بس انا عاوز اعمل اسكل من جوا مش من ماستري لفل |
||||||||||
![]() |
![]() |
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|