السلام عليكم
كنت اريد عمل جدول او فيو يحتوى على عدد كبير من الاعمده ولكن عند تنفيذه يظهر لى الخطأ التالى
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
لذلك ارجو مساعدتكم .. و شكرا
اريد مساعده فى كتابة كود Sql Server
ضوابط المشاركة
المفضلات