cmsdb.sql

用VB实现SQL数据库编程

create database cms
go
use cms
go
create table userinfo(
[user] char(10) primary key not null,
pass char(10) not null)
go
insert into userinfo
values('admin','admin')
go
create table contractinfo(
staffnum varchar(50) not null,
contractname varchar(50),
contractnum varchar(50) not null,
contractdate varchar(50),
constadate varchar(50),
conenddate varchar(50),
isterminate varchar(50),
memo varchar(50),
primary key(staffnum,contractnum)
)
go
insert into contractinfo
values('1234001','1号员工合同','2007101',2,'2007-12-3','2009-12-3',0,'这是第一个合同')
go
insert into contractinfo
values('1234002','2号员工合同','2007102',3,'2004-12-3','2007-12-3',1,null)
go
insert into contractinfo
values('1234003','3号员工合同','2007103',1,'2007-12-3','2008-12-3',0,null)
go
insert into contractinfo
values('1234004','4号员工合同','2007104',2,'2007-1-3','2009-1-3',0,null)
go 
create table corporateinfo(
departmentnum char(10)primary key not null,
departmentname char(20)
)
go
insert into corporateinfo
values('2004001','董事长')
go
create table staffinfo(
staffnum char(10)primary key not null,
staffname char(20)
)
go
insert into staffinfo
values('100001','王飞')