日期:2014-05-18 浏览次数:20748 次
USE [education] GO /****** 对象: Table [dbo].[课程信息] 脚本日期: 10/26/2007 08:59:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[课程信息]( [课程编号] [varchar](14) COLLATE Chinese_PRC_CI_AS NOT NULL, [课程名称] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [拼音码] [char](6) COLLATE Chinese_PRC_CI_AS NULL, [本学期课程] [char](2) COLLATE Chinese_PRC_CI_AS NOT NULL, [开课系别] [varchar](14) COLLATE Chinese_PRC_CI_AS NOT NULL, [理论学分] [smallint] NOT NULL, [实践学分] [smallint] NULL CONSTRAINT [DF_课程信息_实践学分] DEFAULT ((0)), [适用教室类型] [nchar](2) COLLATE Chinese_PRC_CI_AS NOT NULL, [备选教室类型] [nchar](2) COLLATE Chinese_PRC_CI_AS NULL, [教授人数] [smallint] NULL, [课程类别] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_课程信息] PRIMARY KEY CLUSTERED ( [课程编号] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[课程信息] WITH CHECK ADD CONSTRAINT [FK_课程信息_课程类别代码表] FOREIGN KEY([课程类别]) REFERENCES [dbo].[课程类别代码表] ([编号]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[课程信息] CHECK CONSTRAINT [FK_课程信息_课程类别代码表]
------解决方案--------------------
mark
------解决方案--------------------
LZ 把你最耗时的语句贴出来看看
------解决方案--------------------
mark
------解决方案--------------------
细细看看LS贴的那些大段 还是会有不少收获的