创建数据库:
create database jylt
on (
name=jylt,
filename='e:\db\jylt.mdf',
size=4,
filegrowth=100%,
maxsize=1024
)
log on
(
name=jylt_log,
filename='e:\db\jylt_log.ldf',
size=4,
filegrowth=100%
)
go
1,增:insert into t_user values('wangpeng','19');s
2,删:delete from t_user where t_user.age<30
3,改:update t_user name='xiaohong' where name='dahong'
4,查:select name as '名字' age as '年龄' from t_user where name='xiaohong'
check约束: age between 18 and 70 and gongzi 1000 and 3000
use master
go
create database jylt
on (
name=jylt,
filename='e:\db\jylt.mdf',
size=4,
filegrowth=100%,
maxsize=1024)
log on(
name=jylt_log,
filename='e:\db\jylt_log.ldf',
size=4,
filegrowth=100%)
go
use jylt
go
create table t_user
(
uid int primary key identity(1,1) not null,
ulname varchar(50) not null,
ulpwd varchar(50) not null,
unichen varchar(50) null,
uname varchar(50) null,
uaddress varchar(200) null,
usex int ,
utelephone varchar(50) null,
uhomepage varchar(200) null,
uimageurl varchar(200) null,
usignature varchar(200) null
)
go
create table t_reply
(
rid int not null primary key,
uid int foreign key references t_user(uid) ,
rtitle varchar(50),
rcontent varchar(max) not null,
rdatetime datetime default getdate()
)
go
create table t_board
(
bid int primary key not null,
bname varchar(50) not null,
bimgurl varchar(200) null,
binfo varchar(200) null
)
go
create table t_topic
(
tid int primary key not null,
ttitle varchar(50) not null,
tcontent varchar(max) not null,
tdatetime datetime default getdate(),
uid int foreign key references t_user(uid),
tview int default 0,
bid int references t_board(bid)
)
go