假设学生成绩数据库为cj.mdb,存放成绩的表为data,其中chengji的各字段为下表所列: 字段名 字段类型 字段 5
展开全部
创建数据库
CREATE DATABASE [cj] ON PRIMARY
( NAME = N'cj', FILENAME = N'E:\cj.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'cj_log', FILENAME = N'E:\cj_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
创建表
USE [cj]
CREATE TABLE [dbo].[Table_chengji](
[字段名] [nchar](10) NULL,
[字段类型] [nchar](10) NULL,
[字段] [decimal](10, 2) NULL
) ON [PRIMARY]
GO
CREATE DATABASE [cj] ON PRIMARY
( NAME = N'cj', FILENAME = N'E:\cj.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'cj_log', FILENAME = N'E:\cj_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
创建表
USE [cj]
CREATE TABLE [dbo].[Table_chengji](
[字段名] [nchar](10) NULL,
[字段类型] [nchar](10) NULL,
[字段] [decimal](10, 2) NULL
) ON [PRIMARY]
GO
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询