الرئيسية
الأحداث
أحدث الصور
التسجيل
دخول| أخر المشاركات | أفضل الاعضاء هذا الشهر | أفضل 10 اعضاء |
|
|
|
|---|
المشاركة رقم: ( 1 )
asddomتقني نشيط
- المشاركات : 288
نقاط : 394
التقييم : 11
تاريخ التسجيل : 11/01/2012
23.08.13 20:00
السلام عليكم و رحمة الله و بركاتة
زي بالموضوع دورت كثيير بالمنتدى ولا لقيته [ للعلم كان الكود موجود بالمنتدى ايام زمن النهضه .. ]
زي بالموضوع دورت كثيير بالمنتدى ولا لقيته [ للعلم كان الكود موجود بالمنتدى ايام زمن النهضه .. ]
المشاركة رقم: ( 2 )
abodeتقني نشيط- المشاركات : 264
نقاط : 274
التقييم : 0
تاريخ التسجيل : 06/06/2012
25.08.13 7:53
وعليكم السلام...
أخوي المفروض الموضوع بقسم الطلبات...
بس مو مشكله تفضل أخوي هذى كود تطوير الدروب:
- الكود:
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_1] = 1
WHERE [percentage_1] > 0 or [percentage_1] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_2] = 1
WHERE [percentage_2] > 0 or [percentage_2] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_3] = 1
WHERE [percentage_3] > 0 or [percentage_3] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_4] = 1
WHERE [percentage_4] > 0 or [percentage_4] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_5] = 1
WHERE [percentage_5] > 0 or [percentage_5] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_6] = 1
WHERE [percentage_6] > 0 or [percentage_6] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_7] = 1
WHERE [percentage_7] > 0 or [percentage_7] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_8] = 1
WHERE [percentage_8] > 0 or [percentage_8] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_9] = 1
WHERE [percentage_9] > 0 or [percentage_9] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_10] = 1
WHERE [percentage_10] > 0 or [percentage_10] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_11] = 1
WHERE [percentage_11] > 0 or [percentage_11] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_12] = 1
WHERE [percentage_12] > 0 or [percentage_12] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_13] = 1
WHERE [percentage_13] > 0 or [percentage_13] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_14] = 1
WHERE [percentage_14] > 0 or [percentage_14] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_15] = 1
WHERE [percentage_15] > 0 or [percentage_15] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_16] = 1
WHERE [percentage_16] > 0 or [percentage_16] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_17] = 1
WHERE [percentage_17] > 0 or [percentage_17] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_18] = 1
WHERE [percentage_18] > 0 or [percentage_18] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_19] = 1
WHERE [percentage_19] > 0 or [percentage_19] = 0
GO
UPDATE [Arcadia8_1].[dbo].[EnhanceResource]
SET [percentage_20] = 1
WHERE [percentage_20] > 0 or [percentage_20] = 0
GO
update [Arcadia8_1].[dbo].[EnhanceResource]
set [fail_result] = 0
where [fail_result] > 3 or [fail_result] >2 or [fail_result] >1 or [fail_result] = 3 or [fail_result] = 2 or [fail_result] = 1
وهذى كود تطوير الحزام بعد لو تبيه:
- الكود:
USE Arcadia8_1
Update MixResource
set mix_value_03 = 100
where sub01_value_01 = 491002
GO
USE Arcadia8_1
Update MixResource
set mix_value_03 = 100
where sub01_value_01 = 491004
GO
USE Arcadia8_1
Update MixResource
set mix_value_02 = 5
where sub01_value_01 = 491002
GO
USE Arcadia8_1
Update MixResource
set mix_value_02 = 5
where sub01_value_01 = 491004
GO
صلاحيات هذا المنتدى:
لاتستطيع الرد على المواضيع في هذا المنتدى