T-SQL语言问题~~速度救急啊

1 select 学号,姓名,班级 from xk where substing(学号,2,1) = '1' and substing(学号,7,1) in ('1','3','5')
2 select min(willnum) as '最小报名数'，max(willnum) as '最大报名数'，avg(willnum) as '平均报名人数' from course
3 select 列名 from 表明 where couno = 004 or couno = 007 or couno = 013
4 update 表名 set 学生姓名 = '陈晓梅' where 班号 = 01000025
5 select willnum,couname from 表名 where kind = '信息技术' and willnum < avg(willnum)
6 delect 表名 where 学号 = 00000005
7 alter table student add constraint CK_stuNo check(len(stuNo) <= 8)
8 create datebase exam_data
on primary
(
name = 'exam_data',
filename = 'exam_data.mdf',
size = 20mb,
filegrowth = 10%
)
log on
(
name = 'exam_log',
filename = 'exam_log.ldf',
size = 1mb,
maxsize = 5mb,
filegrowth = 1mb
)
9 use exam
create table test
(
testid char(4) not null,
testname varchar(50) not nullm
testtime int
)
alter table exam add constraint PK_testId primary key(testid) --主键
10
insert into 表名 values('数学',120)
insert into 表名 values('英语',120)
12
exec sp_renamedb 'exam','example'
go

1. 查找xk数据库中学号第2个字符是1，第7个字符是1、3、5的学生的学、姓名及所在班级名称。
select 学号,姓名,班级 from xk where substing(学号,2,1) = '1' and substing(学号,7,1) in ('1','3','5')

太多了,懒了

1
select
学号,姓名,班级
from
xk
where
substing(学号,2,1)
=
'1'
and
substing(学号,7,1)
in
('1','3','5')
2
select
min(willnum)
as
'最小报名数'，max(willnum)
as
'最大报名数'，avg(willnum)
as
'平均报名人数'
from
course
3
select
列名
from
表明
where
couno
=
004
or
couno
=
007
or
couno
=
013
4
update
表名
set
学生姓名
=
'陈晓梅'
where
班号
=
01000025
5
select
willnum,couname
from
表名
where
kind
=
'信息技术'
and
willnum
<
avg(willnum)
6
delect
表名
where
学号
=
00000005
7
alter
table
student
add
constraint
CK_stuNo
check(len(stuNo)
<=
8)
8
create
datebase
exam_data
on
primary
(
name
=
'exam_data',
filename
=
'exam_data.mdf',
size
=
20mb,
filegrowth
=
10%
)
log
on
(
name
=
'exam_log',
filename
=
'exam_log.ldf',
size
=
1mb,
maxsize
=
5mb,
filegrowth
=
1mb
)
9
use
exam
create
table
test
(
testid
char(4)
not
null,
testname
varchar(50)
not
nullm
testtime
int
)
alter
table
exam
add
constraint
PK_testId
primary
key(testid)
--主键
10
insert
into
表名
values('数学',120)
insert
into
表名
values('英语',120)
12
exec
sp_renamedb
'exam','example'
go