use master
go
IF EXISTS (
SELECT
*
FROM
master..sysdatabases
WHERE
name
= N
'LeaveWord'
)
DROP
DATABASE
leaveword
GO
CREATE
DATABASE
LeaveWord
GO
use LeaveWord
go
create
table
Message
(
MessageID
int
identity(1,1)
primary
key
,
Username
varchar
(20)
not
null
,
Email
varchar
(50),
Content
varchar
(500)
not
null
,
Pubdate datetime
default
(getdate()),
Topdate datetime
default
(getdate())
)
go
select
*
from
Message;
go
go
insert
into
Message(Username,Email,Content)
values
(
'ylb'
,
'ylb@qq.com'
,
'今天天气真好!'
);
go
create
table
Admin
(
AdminName
varchar
(20)
not
null
unique
,
Userpass
varchar
(20)
not
null
)
go
go
insert
into
Admin(AdminName,Userpass)
values
(
'admin'
,
'abc'
);
go
select
count
(*)
from
Admin
where
AdminName=
'admin'
and
Userpass=
'abc'
;
go
select
count
(*)
from
Admin
where
AdminName=
'admin'
and
Userpass=
'abc'
;
go
update
Admin
set
Userpass=
'123'
where
AdminName=
'admin'
;
go
go
go
update
Message
set
Content=
'wanhuijia'
where
MessageID=1;
go
update
Message
set
TopDate=
'2012-2-2'
where
MessageID=1;
go
update
Message
set
TopDate=
null
where
MessageID=1;