如何在sql server management studio中查看列表中插出入的数据的值
1个回答
2015-12-07
展开全部
如果是想用SQL语言来操作的话呢,那就在建立好连接的基础上,然后点击窗体上面的“新建查询”按钮,然后在窗体右边会出现一块编辑区,你在编辑区域里面书写相应的SQL语句就可以。
下面是我写的一个例子,你可以参考下:
现在是建立数据库的SQL语句:
use master
create database stuDB
on
(
name='stuDB', size=5mb,filegrowth=15%, filename='E:\B\stuDB.mdf'
)
log on
(
name='stuDB_log',size=1mb,maxsize=6mb,filename='E:\B\stuDB_log.ldf'
)
use stuDB
go
下面呢,是在新建好的数据库中新建数据表:
create table stuInfo
(
stuName varchar(32) not null,
stuNo varchar(16) not null primary key ,
stuSex varchar(8) not null default('男'),
stuAge int not null,
stuSeat int not null identity(1,1),
stuAddress ntext default('地址不详')
)
以下是为新建好的数据表添加约束:
alter table stuInfo
add constraint ck_stuNo check (stuNo like 's253xx')
alter table stuInfo
add constraint ck_stuAge check (stuAge>=15 and stuAge<=50)
下面是给数据表添加数据:
insert into stuInfo(stuName,stuNo,stuSex,stuAge,stuAddress)
values('张秋丽','s25301',default,18,'北京海淀')
insert into stuInfo(stuName,stuNo,stuSex,stuAge,stuAddress)
values('李斯文','s25303','女',22,'河南洛阳')
insert into stuInfo(stuName,stuNo,stuSex,stuAge,stuAddress)
values('李文才','s25302',default,31,'')
insert into stuInfo(stuName,stuNo,stuSex,stuAge,stuAddress)
values('欧阳骏雄','s25304',default,28,'新疆克拉玛依')
下面是查询表中的所有数据
select *from stuInfo
select stuName as 姓名,stuNo as 学号,stuSex as 性别,stuAge as 年龄,stuSeat as 座号,stuAddress as 家庭住址
from stuInfo
同样,也是新建数据表的语句块:
create table stuMarks
(
examNo varchar(32) not null primary key,
stuNo varchar(16) not null,
writtenExam int default(0),
labExam int default(0)
)
添加约束:
alter table stuMarks
add constraint ck_examNo check (examNo like 'E200507xxxx')
alter table stuMarks
add constraint fk_stuNo foreign key (stuNo) references stuInfo(stuNo)
alter table stuMarks
add constraint ck_writtenExam check (writtenExam>0 and writtenExam<=100)
alter table stuMarks
add constraint ck_labExam check (labExam>0 and labExam<=100)
添加数据到数据表:
insert into stuMarks(examNo,stuNo,writtenExam,labExam) values('E2005070001',
's25301',80,58)
insert into stuMarks(examNo,stuNo,writtenExam,labExam) values('E2005070002',
's25302',50,default)
insert into stuMarks(examNo,stuNo,writtenExam,labExam) values('E2005070003',
's25303',97,82)
下面就是一些简单的查询了:
select examNo as 考号,stuNo as 学号,writtenExam as 笔试成绩,labExam as 试验成绩
from stuMarks
select stuName as 姓名,stuNo as 学号,stuSex as 性别,stuAge as 年龄,stuSeat as 座号,stuAddress as 家庭住址
from stuInfo
select *from stuInfo
where stuSex='男'
order by stuSeat desc
select * from stuMarks
where writtenExam>75 and writtenExam<=100
order by stuNo
select* from stuMarks
where writtenExam <>0 and labExam <>0
select stuName,writtenExam,labExam
into lingshi
from stuInfo,stuMarks
以下就是SQL的聚合函数部分了:
select avg(writtenExam) as 笔试平均成绩 from stuMarks
select avg(labExam) as 机试平均成绩 from stuMarks
select count(*) as 考试人数 from stuMarks where writtenExam>60
select count(*) as 没有通过考试的人数 from stuMarks where writtenExam<60
下面是我写的一个例子,你可以参考下:
现在是建立数据库的SQL语句:
use master
create database stuDB
on
(
name='stuDB', size=5mb,filegrowth=15%, filename='E:\B\stuDB.mdf'
)
log on
(
name='stuDB_log',size=1mb,maxsize=6mb,filename='E:\B\stuDB_log.ldf'
)
use stuDB
go
下面呢,是在新建好的数据库中新建数据表:
create table stuInfo
(
stuName varchar(32) not null,
stuNo varchar(16) not null primary key ,
stuSex varchar(8) not null default('男'),
stuAge int not null,
stuSeat int not null identity(1,1),
stuAddress ntext default('地址不详')
)
以下是为新建好的数据表添加约束:
alter table stuInfo
add constraint ck_stuNo check (stuNo like 's253xx')
alter table stuInfo
add constraint ck_stuAge check (stuAge>=15 and stuAge<=50)
下面是给数据表添加数据:
insert into stuInfo(stuName,stuNo,stuSex,stuAge,stuAddress)
values('张秋丽','s25301',default,18,'北京海淀')
insert into stuInfo(stuName,stuNo,stuSex,stuAge,stuAddress)
values('李斯文','s25303','女',22,'河南洛阳')
insert into stuInfo(stuName,stuNo,stuSex,stuAge,stuAddress)
values('李文才','s25302',default,31,'')
insert into stuInfo(stuName,stuNo,stuSex,stuAge,stuAddress)
values('欧阳骏雄','s25304',default,28,'新疆克拉玛依')
下面是查询表中的所有数据
select *from stuInfo
select stuName as 姓名,stuNo as 学号,stuSex as 性别,stuAge as 年龄,stuSeat as 座号,stuAddress as 家庭住址
from stuInfo
同样,也是新建数据表的语句块:
create table stuMarks
(
examNo varchar(32) not null primary key,
stuNo varchar(16) not null,
writtenExam int default(0),
labExam int default(0)
)
添加约束:
alter table stuMarks
add constraint ck_examNo check (examNo like 'E200507xxxx')
alter table stuMarks
add constraint fk_stuNo foreign key (stuNo) references stuInfo(stuNo)
alter table stuMarks
add constraint ck_writtenExam check (writtenExam>0 and writtenExam<=100)
alter table stuMarks
add constraint ck_labExam check (labExam>0 and labExam<=100)
添加数据到数据表:
insert into stuMarks(examNo,stuNo,writtenExam,labExam) values('E2005070001',
's25301',80,58)
insert into stuMarks(examNo,stuNo,writtenExam,labExam) values('E2005070002',
's25302',50,default)
insert into stuMarks(examNo,stuNo,writtenExam,labExam) values('E2005070003',
's25303',97,82)
下面就是一些简单的查询了:
select examNo as 考号,stuNo as 学号,writtenExam as 笔试成绩,labExam as 试验成绩
from stuMarks
select stuName as 姓名,stuNo as 学号,stuSex as 性别,stuAge as 年龄,stuSeat as 座号,stuAddress as 家庭住址
from stuInfo
select *from stuInfo
where stuSex='男'
order by stuSeat desc
select * from stuMarks
where writtenExam>75 and writtenExam<=100
order by stuNo
select* from stuMarks
where writtenExam <>0 and labExam <>0
select stuName,writtenExam,labExam
into lingshi
from stuInfo,stuMarks
以下就是SQL的聚合函数部分了:
select avg(writtenExam) as 笔试平均成绩 from stuMarks
select avg(labExam) as 机试平均成绩 from stuMarks
select count(*) as 考试人数 from stuMarks where writtenExam>60
select count(*) as 没有通过考试的人数 from stuMarks where writtenExam<60
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询
广告 您可能关注的内容 |