无标题1.sql

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

select * from orders

insert Orders values ('00001','00001','001','love',1,getdate(),dateadd(dd,2,getdate()),5)

update love set istock=0 where cid='001'

select * from love 

select * from member

update member set mMoney=100 where cMemberID='00004'

drop table orders

create table Orders
(  cOrderNo char (5),
   cMemberID char(5),
   cVCDName char (100),
   cType char (20),
   iRentNum int,
   dOrderDate datetime,
   dReturnDate datetime,
   iRental int
)
select * from manager

create table Orderdetails
(  
   cMemberID char(5),
   cVCDName char (100),
   cType char (20),
   iRentNum int,
   dOrderDate datetime,
   dReturnDate datetime,
   iRental int
)

drop table orderdetails

select * from orderdetails

update love set istock =istock-1 where cname ='我的失忆男友'

select * from love