[MS SQL]高级SQL总结

 

--------------------创建文件包
exec sp_configure'show advanced options',1
RECONFIGURE
exec sp_configure'xp_cmdshell',1
RECONFIGURE
exec xp_cmdshell 'md d:\project'
go
use master 
go
--创建bbsDB数据库
if exists(select name from sysdatabases where name='bbsDB')
	drop database bbsDB
go
create database bbsDB
on
(
	name='bbsDB',
	filename='d:\project\bbsBD.mdf',
	size=10mb,
	filegrowth=15%
)
log on
(
	name='bbsDB_log',
	filename='d:\project\bbsBD_log.ldf',
	size=3mb,
	maxsize=20mb,
	filegrowth=15%
)
--创建 bbsUsers 表
use bbsDB
go
if exists(select name from sysobjects where name='bbsUsers')
	drop table bbsUsers
go
create table bbsUsers
(
	UID int identity(1,1) not null, --用户编号
	Uname varchar(15) not null,		--用户名
	Upassword varchar(10) not null,	--密码
	Uemail varchar(20),				--邮箱
	Usex bit	not null,			--性别
	Uclass i