shaghayegh_miri
دوشنبه 21 دی 1383, 15:15 عصر
با سلام به دوستان
من میخوام اسکریپت زیر روبرای ایجاد جدول اجرا کنم اما این error رو میده
Warning: The table 'tblStation' has been created but its maximum row size (9077) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
اسکریپت
CREATE TABLE [tblStation] (
[id] [int] NULL ,
[fcity] [nvarchar] (50) COLLATE Arabic_CI_AS Not NULL ,
[ecity] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StationID] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CityCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ProvinceID] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CountryCode] [int] NULL ,
[Height] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LangitudeDeg] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LatitudeDeg] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LangitudeMin] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LatitudeMin] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[codetype] [int] NULL ,
[foreign] [bit] NOT NULL ,
[touch] [int] NULL ,
[timezone] [sql_variant] NULL
) ON [PRIMARY]
GO
کسی میدونه اشکال از کجاست؟
من میخوام اسکریپت زیر روبرای ایجاد جدول اجرا کنم اما این error رو میده
Warning: The table 'tblStation' has been created but its maximum row size (9077) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
اسکریپت
CREATE TABLE [tblStation] (
[id] [int] NULL ,
[fcity] [nvarchar] (50) COLLATE Arabic_CI_AS Not NULL ,
[ecity] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StationID] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CityCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ProvinceID] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CountryCode] [int] NULL ,
[Height] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LangitudeDeg] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LatitudeDeg] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LangitudeMin] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LatitudeMin] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[codetype] [int] NULL ,
[foreign] [bit] NOT NULL ,
[touch] [int] NULL ,
[timezone] [sql_variant] NULL
) ON [PRIMARY]
GO
کسی میدونه اشکال از کجاست؟