النتائج 1 إلى 2 من 2

الموضوع: اريد مساعده فى كتابة كود Sql Server

  1. #1
    عضوية جديدة
    تاريخ التسجيل
    Jan 2012
    المشاركات
    10
    معدل تقييم المستوى
    0

    Question اريد مساعده فى كتابة كود Sql Server



    السلام عليكم
    كنت اريد عمل جدول او فيو يحتوى على عدد كبير من الاعمده ولكن عند تنفيذه يظهر لى الخطأ التالى

    Msg 4506, Level 16, State 1, Procedure myView22, Line 3
    Column names in each view or function must be unique. Column name '8BATI412BA' in view or function 'myView22' is specified more than once.


    مع العلم انه لا يوجد اى عمود مكرر و عند تغيير اسم العمود
    '8BATI412BA' يظهر نفس الخطأ و لكن لاسم عمود أخر
    و الكود الذى اقوم بكتابته هو كالتالى


    CREATE VIEW myView22
    AS
    SELECT
    [F1] AS [TIME] , [F2] AS [8TOTAIRFLOW] , [F3] AS [8BAPI404A] , [F4] AS [8BAPI404B] , [F5] AS [8BAPDI402A] ,
    [CAIRO WEST POWER STATION UNIT 8 ] AS [8BAPDI402B] , [F7] AS [8BAII601A] , [F8] AS [8BAII601B] , [F9] AS [8BAFI413AA] ,
    [F10] AS [8BAFI413AB] , [F11] AS [8BAFI413AC] , [F12] AS [8BATI412AA] , [F13] AS [8BATI412BA] , [F14] AS [8BAFI413BA] ,
    [F15] AS [8BAFI413BB] , [F16] AS [8BAFI413BC] , [F17] AS [8BATI412BA] , [F18] AS [8BATI412BB] , [F19] AS [8BAPI444A] ,
    [F20] AS [8BAPI444B] , [F21] AS [8BATI407AA] , [F22] AS [8BATI407AB] , [F23] AS [8BATI407AC] , [F24] AS [8BATI407BA] ,
    [F25] AS [8BATI407BB] , [F26] AS [8BATI407BC] , [F27] AS [8BATI445A] , [F28] AS [8BATI445B] , [F29] AS [8BAPDI450A] ,
    [F30] AS [8BAPDI450B] , [F31] AS [8BATI453AA] , [F32] AS [8BATI453AB] , [F33] AS [8BATI453AC] , [F34] AS [8BATI453BA] ,
    [F35] AS [8BATI453BB] , [F36] AS [8BATI453BC] , [F37] AS [8BAZI413AA] , [F38] AS [8BAZI413AB] , [F39] AS [8BAZI431A] ,
    [F40] AS [8BAZI431B] , [F41] AS [8BAPDI461A] , [F42] AS [8BAPDI461B] , [F43] AS [8BAPI463A] , [F44] AS [8BAPI463B] ,
    [F45] AS [8BAII602A] , [F46] AS [8BAPI420AA] , [F47] AS [8BAII602B] , [F48] AS [8BAPI420AB] , [F49] AS [8BAPI420BA] ,
    [F50] AS [8BAPI420BB] , [F51] AS [8BAPI427] , [F52] AS [8BAPDI426] , [F53] AS [8BATI428] , [F54] AS [8BAZI413AB] ,
    [F55] AS [8BAZI413BB] , [F56] AS [8BAZI413AC] , [F57] AS [8BAZI413BC] , [F58] AS [8BAZI413AD] , [F59] AS [8BAZI413BD] ,
    [F60] AS [8JNAI541] , [F61] AS [8JNAI542] , [F62] AS [8JNAI543] , [F63] AS [8JNAI545] , [F64] AS [8JNAI544] ,
    [F65] AS [8AATI407A] , [F66] AS [8AATI407B] , [F67] AS [8AAPI418A] , [F68] AS [8AAPI418B] , [F69] AS [8AEFI060A] ,
    [F70] AS [8AEFI060B] , [F71] AS [8AETI058] , [F72] AS [8AEFI407] , [F73] AS [8AEFI410] , [F74] AS [8AEFI415] ,
    [F75] AS [8AETI406] , [F76] AS [8AETI019] , [F77] AS [8AEPI041] , [F78] AS [8AEPI040A] , [F79] AS [8AEPI040B] ,
    [F80] AS [8ABTI044A] , [F81] AS [8ABTI044B] , [F82] AS [8AATI443A] , [F83] AS [8AATI443B] , [F84] AS [8AATI436A] ,
    [F85] AS [8AATI436B] , [F86] AS [8AATI432A] , [F87] AS [8AATI432B] , [F88] AS [8ABTI047A] , [F89] AS [8ABTI047B] ,
    [F90] AS [8ABPI036] , [F91] AS [8ABTI015] , [F92] AS [8AAZI508] , [F93] AS [8AAZI512] , [F94] AS [8AAZI510] ,
    [F95] AS [8FGFI405CDQ] , [F96] AS [8FGFI405ABQ] , [F97] AS [8FOFI433A] , [F98] AS [8MNGASFLESEL] ,
    [F99] AS [80CHC00CE002S] , [F100] AS [8AATI415A] , [F101] AS [8AATI415B] , [F102] AS [8AATI415C] , [F103] AS [8AATI415D] ,
    [F104] AS [8AATI415E] , [F105] AS [8AATI415F] , [F106] AS [8FGJY405] , [F107] AS [8WOFLOW] , [F108] AS [8FOIPI408] ,
    [F109] AS [8FOFI433A] , [F110] AS [8FOTI431] , [F111] AS [8FOFI462] , [F112] AS [8FGTI406] , [F113] AS [8FGPI424] ,
    [F114] AS [8FGPI426] , [F115] AS [8BAAI440AA] , [F116] AS [8BAAI440AB] , [F117] AS [8BAAI440BA] , [F118] AS [8BAAI440BB] ,
    [F119] AS [8BAAI442AA] , [F120] AS [8BAAI442AB] , [F121] AS [8BAAI442AC] , [F122] AS [8BAAI442BA] , [F123] AS [8BAAI442BB] ,
    [F124] AS [8BAAI442BC]




    FROM [Test].[dbo].[D20110601.xls]




    with check option
    لذلك ارجو مساعدتكم .. و شكرا

  2. #2
    عضوية جديدة
    تاريخ التسجيل
    Jan 2012
    المشاركات
    10
    معدل تقييم المستوى
    0

    رد: اريد مساعده فى كتابة كود Sql Server



    الحمد لله تم اكتشاف اعمده متشابهه.

المواضيع المتشابهه

  1. اريد مساعده فى كتابة كود Sql Server
    بواسطة egypt_nemo في المنتدى منتدى الشهادات العام
    مشاركات: 4
    آخر مشاركة: 05-04-2012, 09:26
  2. اريد كتابة هذا البرنامج في السي شارب --- ارجوووكم
    بواسطة امل بكره في المنتدى البرمجه والتصميمات الفنيه ( الجرافيكس )
    مشاركات: 5
    آخر مشاركة: 08-12-2011, 17:48
  3. مشاركات: 9
    آخر مشاركة: 25-09-2004, 11:51

الكلمات الدلالية لهذا الموضوع

المفضلات

ضوابط المشاركة

  • لا تستطيع إضافة مواضيع جديدة
  • لا تستطيع الرد على المواضيع
  • لا تستطيع إرفاق ملفات
  • لا تستطيع تعديل مشاركاتك
  •