CREATE TABLE [movie] (
[movie_no] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[title] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[year] [int] NULL ,
[length] [int] NULL ,
[incolor] [smallint] NULL ,
[cert#] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
PRIMARY KEY CLUSTERED
(
[movie_no]
) ON [PRIMARY] ,
CONSTRAINT [CK_movie] CHECK ([year] > 1990 && [year]<select year(getdate()))
CONSTRAINT [CK_length] CHECK([length]>60 &&[length]<250)
) ON [PRIMARY]
GO
[movie_no] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[title] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[year] [int] NULL ,
[length] [int] NULL ,
[incolor] [smallint] NULL ,
[cert#] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
PRIMARY KEY CLUSTERED
(
[movie_no]
) ON [PRIMARY] ,
CONSTRAINT [CK_movie] CHECK ([year] > 1990 && [year]<select year(getdate()))
CONSTRAINT [CK_length] CHECK([length]>60 &&[length]<250)
) ON [PRIMARY]
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货