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

الموضوع: اريد مساعده فى كتابة كود 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
    عضو الصورة الرمزية Michael Youssef
    تاريخ التسجيل
    Mar 2012
    المشاركات
    435
    معدل تقييم المستوى
    13

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

    الاسم متكرر في
    [F13] AS [8BATI412BA] [F17] AS [8BATI412BA]
    SQL Server Enthusiast
    MCSE & MCSA WINDOWS Server 2000
    MCDBA SQL Server 2000
    MCAD & MCSD .NET
    MCPD C# Windows App Developer
    MCITP SQL Server 2005 Developer
    MCITP SQL Server 2008 Administrator
    MY C# & ASP.NET Articles

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

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

    الف شكر ...

  4. #4
    مشرف سابق الصورة الرمزية A Beautiful Mind
    تاريخ التسجيل
    Aug 2009
    المشاركات
    2,611
    الدولة: Egypt
    معدل تقييم المستوى
    44

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

    اقتباس المشاركة الأصلية كتبت بواسطة Michael Youssef مشاهدة المشاركة
    الاسم متكرر في
    [F13] AS [8BATI412BA] [F17] AS [8BATI412BA]
    تسلم ايدك يا باشمهندس ربنا يوفقك دوما
    معنى كده انه تم حل الكود بنجاح والمشكله فقط فى هذا
    Closed

  5. #5
    عضو الصورة الرمزية Michael Youssef
    تاريخ التسجيل
    Mar 2012
    المشاركات
    435
    معدل تقييم المستوى
    13

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

    اه كأنك رايح تسمي توأم أحمد و أحمد ، الموظف هيقولك لا مش ينفع
    SQL Server Enthusiast
    MCSE & MCSA WINDOWS Server 2000
    MCDBA SQL Server 2000
    MCAD & MCSD .NET
    MCPD C# Windows App Developer
    MCITP SQL Server 2005 Developer
    MCITP SQL Server 2008 Administrator
    MY C# & ASP.NET Articles

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

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

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

المفضلات

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

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