数据库学习部分
创建pubs数据库,脚本:
USE [pubs]
GO
/****** Object: Table [dbo].[students] Script Date: 05/05/2013 16:17:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[students](
[学号] [int] NOT NULL,
[姓名] [varchar](50) NULL,
[数学成绩] [int] NULL,
[英语成绩] [int] NULL,
[物理成绩] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
截图如下:
数据有:
所有的代码可在http://download.csdn.net/detail/snicolashe/5333181处下载。