无标题1.sql

来自「订购火车票」· SQL 代码 · 共 81 行

/*--建数据库--*/
use master
if exists(select * from sysdatabases where name='TicketDB')
 drop database TicketDB
go
exec xp_cmdshell 'mkdir D:\dianying\data'--在D盘建文件夹
go
create database TicketDB
on 
(
name='TicketDB_data',
fileName='D:\dianying\data\TicketDB_data.mdf',
size=2mb,
filegrowth=15%
)
log on
(
name='TicketDB_log',
fileName='D:\dianying\data\TicketDB_log.ldf',
size=1mb,
filegrowth=15%
)
go
/*--创建表--*/
use TicketDB
if exists(select * from sysobjects where name='Ticket')
drop table Ticket

create table Ticket
(
Seat varchar(25) not null,--电影票销售
[Sign] bit not null,--销售标志
)
go
alter table Ticket add constraint pk_Seat primary key(Seat),--添加主键
constraint df_Sign default('0') for [Sign]--默认为0


/*----插入语句测试------*/
--总共25条记录


insert into Ticket(Seat) values (11)
insert into Ticket(Seat) values (12)
insert into Ticket(Seat) values (13)
insert into Ticket(Seat) values (14)
insert into Ticket(Seat) values (15)


insert into Ticket(Seat) values (21)
insert into Ticket(Seat) values (22)
insert into Ticket(Seat) values (23)
insert into Ticket(Seat) values (24)
insert into Ticket(Seat) values (25)


insert into Ticket(Seat) values (31)
insert into Ticket(Seat) values (32)
insert into Ticket(Seat) values (33)
insert into Ticket(Seat) values (34)
insert into Ticket(Seat) values (35)



insert into Ticket(Seat) values (41)
insert into Ticket(Seat) values (42)
insert into Ticket(Seat) values (43)
insert into Ticket(Seat) values (44)
insert into Ticket(Seat) values (45)

insert into Ticket(Seat) values (51)
insert into Ticket(Seat) values (52)
insert into Ticket(Seat) values (53)
insert into Ticket(Seat) values (54)
insert into Ticket(Seat) values (55)


select * from Ticket

update Ticket set [Sign]=1 where Seat like '_1'