values('小昭','男','1987-6-9','78945678945','山东',4)

　　insert into Student values('小溪','男','1982-6-9','65987845651','抚顺',3)

　　insert into Student values('小怜','男','1981-6-9','25487965423','天津',5)

　　insert into Student(name,sex,birthday,phone,tId) values('李真','男','1984-6-9','25487965423',5)

　　select * from Team

　　select * from Student

　　if exists (select * from sysobjects where name='teacher')

　　drop table teacher

　　go

　　create table teacher

　　(

　　id int identity (1,1) primary key,

　　name varchar(20),

　　address varchar(20)

　　)

　　go

　　insert into teacher values('zhang','hubei')

　　insert into teacher values('wang','hubei')

　　insert into teacher values('li','hubei')

　　insert into teacher values('chen','hunan')

　　insert into teacher values('zhao','hunan')

　　insert into teacher values('tian','guangdong')

　　insert into teacher values('ma','guangdong')

　　insert into teacher values('chang','tianjin')

　　insert into teacher values('liang','beijing')

　　select * from teacher

　　select count(*),address from teacher group by address having address<>'hunan'

　　--按地址分组查询并用having字句筛选出地址不是‘hunan’的

　　EXEC sp_configure 'xp_cmdshell', 0

　　GO

　　-- 还原当前功能（xp_cmdshell）的配置信息为初始状态.

　　RECONFIGURE

　　GO

　　EXEC sp_configure 'show advanced options', 0

　　GO

　　-- 最后，还原当前高级选项的配置信息为初始状态

　　RECONFIGURE

　　GO