服务器维护网站维护数据维护系统安全配置
专业定制网站企业建站一条龙、软件定制开发、系统集成
稳定虚机备案一条龙，稳定快捷通道
服务理念诚信守诺客户至上专业精神专心贯注

SQL数据库2005中用语句的创建数据库和表(2)

作者：黑客防线网安SQL维护基地来源：黑客防线网安SQL维护基地浏览次数：0

本篇关键词：SQL2005 数据库

黑客防线网安网讯： insert into teacher values(&#39;zhang&#39;,&#39;hubei&#39;)insert into teacher values(&#39;wang&#39;,&#39;hubei&#39;)insert into teacher values(&#39;li&#39;,&#39;hubei&#39;)...

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