自己做的小型新闻发布系统

create database xinwen use xinwen create table news ( newsID int identity(1,1) primary key, newsTitle varchar(50) not null, newsContent varchar(200) not null, addTime smalldatetime not null, author varchar(20) not null ) insert into news values('title1','content1','2008.02.3','kxq') insert into news values('title2','content1','2008.02.3','kxq') insert into news values('title3','content1','2008.02.3','kxq') insert into news values('title4','content1','2008.02.3','kxq') insert into news values('title5','content1','2008.02.3','kxq') select * from news create table users ( usersID int identity(1,1) primary key, userName varchar(20) not null, userPwd varchar(20) not null ) insert into users values('admin','admin') select * from users