數據庫學習部分
創建pubs數據庫,腳本:
[sql]
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
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
截圖如下:
數據有: