sql新建数据库

USE [master]

GO

--创建数据库 --FILENAME 是你数据库文件的存放路径 自己改

CREATE DATABASE [User] ON PRIMARY

( NAME = N'User', FILENAME = N'E:\test\Usermdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )

LOG ON

( NAME = N'User_log', FILENAME = N'E:\test\User_logldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

GO

--创建表

USE [User]

GO

CREATE TABLE [dbo][t_dept](

[deptno] [int] IDENTITY(1,1) NOT NULL,

[deptname] [nvarchar](500) NOT NULL,

CONSTRAINT [PK_t_dept] PRIMARY KEY CLUSTERED

(

[deptno] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

CREATE TABLE [dbo][t_class](

[classno] [int] IDENTITY(1,1) NOT NULL,

[classname] [nvarchar](500) NOT NULL,

CONSTRAINT [PK_t_class] PRIMARY KEY CLUSTERED

(

[classno] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

CREATE TABLE [dbo][t_user](

[userid] [int] NOT NULL,

[username] [nvarchar](500) NOT NULL,

[deptno] [int] NOT NULL,

[classno] [int] NOT NULL,

[password] [varchar](500) NOT NULL,

CONSTRAINT [PK_t_user] PRIMARY KEY CLUSTERED

(

[userid] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

--插入数据

use [user]

go

insert into t_class values('2004级1班')

insert into t_class values('2004级2班')

insert into t_class values('2004级3班')

insert into t_class values('2004级4班')

insert into t_class values('2004级5班')

insert into t_dept values('数学系')

insert into t_dept values('计算机系')

insert into t_dept values('历史系')

insert into t_dept values('经济系')

insert into t_dept values('中文系')

insert into t_user(userid,username,deptno,classno,password)

values(2004021,'用心',1,1,'yongxin')

insert into t_user(userid,username,deptno,classno,password)

values(2004022,'李牛',1,2,'yongxin')

insert into t_user(userid,username,deptno,classno,password)

values(2004023,'王虎',2,1,'yongxin')

insert into t_user(userid,username,deptno,classno,password)

values(2004024,'乖乖',2,2,'yongxin')

insert into t_user(userid,username,deptno,classno,password)

values(2004025,'帅哥',4,1,'yongxin')

--file name 你自己设置下路径

--密码没加密 写的明文 自己插入加密值

--测试版本ssms 2005

服务器名称 你安装的时候不是让你选嘛

Mcrosoft SQL Server 2005一般默认是：

电脑名\SQLEXPRESS

另外登陆验证看你当初选的是由OS验证还是独立验证了。

以上就是关于sql新建数据库全部的内容，包括:sql新建数据库、关于第一次使用SQL Server中的服务器名称、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！