sql1.sql

原创VB+SQL影音租赁系统 醮简单 具体看里边的文本文档

insert Orders values ('00001','00001','001','love',1,getdate(),dateadd(dd,2,getdate()),5)
drop table love,cartoon,comedy,war,art,advertisement,terror,venture,science,action
sp_help
create table Member
( cMemberID char (5),
  cMemberName char (10),
  mMoney money,
  cAge char (3),
  cSex char (4),
  cEmail char (30),
  cAddress char (40),
  cPostcode char (6),
  cPhone char (20),
  cCardnum char (18)
)
select * from customer

create table Love
( cID char (5),
  cName char (20),
  cLanguage char (15),
  cLenth char (3),
  dPublishDate datetime,
  iPrice int,
  cParts char (50),
  cDirector char (15),
  cStory char (2000),
  cPicpath char (200),
  cLevel char (10),
  iStock int
)

create table Comedy
( cID char (5),
  cName char (20),
  cLanguage char (15),
  cLenth char (3),
  dPublishDate datetime,
  iPrice int,
  cParts char (50),
  cDirector char (15),
  cStory char (2000),
  cPicpath char (200),
  cLevel char (10),
  iStock int
)

create table Cartoon
( cID char (5),
  cName char (20),
  cLanguage char (15),
  cLenth char (3),
  dPublishDate datetime,
  iPrice int,
  cParts char (50),
  cDirector char (15),
  cStory char (2000),
  cPicpath char (200),
  cLevel char (10),
  iStock int
)

create table Science
( cID char (5),
  cName char (20),
  cLanguage char (15),
  cLenth char (3),
  dPublishDate datetime,
  iPrice int,
  cParts char (50),
  cDirector char (15),
  cStory char (2000),
  cPicpath char (200),
  cLevel char (10),
  iStock int
)

create table Terror（恐怖）
( cID char (5),
  cName char (20),
  cLanguage char (15),
  cLenth char (3),
  dPublishDate datetime,
  iPrice int,
  cParts char (50),
  cDirector char (15),
  cStory char (2000),
  cPicpath char (200),
  cLevel char (10),
  iStock int
)

create table War
( cID char (5),
  cName char (20),
  cLanguage char (15),
  cLenth char (3),
  dPublishDate datetime,
  iPrice int,
  cParts char (50),
  cDirector char (15),
  cStory char (2000),
  cPicpath char (200),
  cLevel char (10),
  iStock int
)


create table Action
( cID char (5),
  cName char (20),
  cLanguage char (15),
  cLenth char (3),
  dPublishDate datetime,
  iPrice int,
  cParts char (50),
  cDirector char (15),
  cStory char (2000),
  cPicpath char (200),
  cLevel char (10),
  iStock int
)
create table Venture(冒险)
( cID char (5),
  cName char (20),
  cLanguage char (15),
  cLenth char (3),
  dPublishDate datetime,
  iPrice int,
  cParts char (50),
  cDirector char (15),
  cStory char (2000),
  cPicpath char (200),
  cLevel char (10),
  iStock int
)


create table Art
( cID char (5),
  cName char (20),
  cLanguage char (15),
  cLenth char (3),
  dPublishDate datetime,
  iPrice int,
  cParts char (50),
  cDirector char (15),
  cStory char (2000),
  cPicpath char (200),
  cLevel char (10),
  iStock int
)


create table advertisement
( cID char (5),
  cName char (20),
  cLanguage char (15),
  cLenth char (3),
  dPublishDate datetime,
  mPrice money,
  cParts char (50),
  cDirector char (15),
  cStory char (2000),
  cPicpath char (200),
  cLevel char (10),
  iStock int
)

create table Orders
(  cOrderNo char (5),
   cMemberID char(5),
   cVCDName char (100),
   cType char (20),
   iRentNum int,
   dOrderDate datetime,
   dcReturnDate datetime,
   dfReturnDate datetime,
   iRental int
)

create table Orderdetails
(  
   cOrderNo char (5),
   cMemberID char(5),
   cVCDName char (100),
   cType char (20),
   iRentNum int,
   dOrderDate datetime,
   dcReturnDate datetime,
   dfReturnDate datetime,
   iRental int
)
create table rent 
(  cCustomerID char (5),
   cOrderNo char (5),
   cID char (3),
   dRentDate datetime,
   iRentNum int,
   iRental int
)

create table Manager
(   cManageID char (5),
    cPassword char (10),
    cName     char (10),
    cAge      char (3),
    cEmail    char (20),
    cTel      char (15),
    cAddress  char (100)
)