SqlServer基础笔记测试数据库

新建查询，复制下面代码执行（按F5） 

❗如果有错误请截图发往博主邮箱❗

use [master]
GO

if DB_ID('class') is not null
drop database class;
GO

if DB_ID('class') is null
create database class;
GO

use [class]
go

if exists(select * from sysobjects where name = 'student')
drop table student
go

create table [dbo].[student](
	[id] [int] identity(1,1),
	[name] [varchar](50) not null,
	[course] [varchar](50) not null,
	[score] [int] not null
)ON [PRIMARY]
go

insert into student(name,course,score) values('小明','数学',48)
insert into student(name,course,score) values('小明','语文',56)
insert into student(name,course,score) values('小明','英语',34)
insert into student(name,course,score) values('小王','数学',112)
insert into student(name,course,score) values('小王','语文',45)
insert into student(name,course,score) values('小王','英语',56)
insert into student(name,course,score) values('小赵','数学',45)
insert into student(name,course,score) values('小赵','语文',78)
insert int