数据库文件

IF exists(select * from mater.sysdatabases where name='db_09zy')
drop database db_09zy
go
create database zy
on primary(
name='zy_data',
filename='E:/09.9zy1/zy_data.mdf',
size=10mb,
MAXSIZE=UNLIMITED,
filegrowth=20%
)
log on (name='zye_data.ldf',
FILENAME='E://09.9zy1/zyE_data.ldf',
size=10mb,
maxsize=unlimited,
filegrowth=20%
)
go

USE zy
GO
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='TB_TITLE'AND TYPE='U')
DROP TABLE TB_TITLE
GO
CREATE TABLE TB_TITLE
(       
ID INT NOT NULL IDENTITY (1,1)PRIMARY KEY,
TITLE VARCHAR(100)NULL,
Names varchar(20)null
)
go
select*FROM TB_TITLE

USE zy
go
insert into TB_TITLE VALUES('这儿有事哦！','丁丽琴')
go

USE zy
GO
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='tb_cpin'AND TYPE='U')
DROP TABLE tb_cpin
GO
CREATE TABLE tb_cpin
(       
ID INT NOT NULL IDENTITY (1,1)PRIMARY KEY,
Images varchar(50)null,
goodsname varchar(20)null,
price varchar(20)null,
nowprice varchar(20)null,
Intro varchar(100)null
)
go
select*from tb_cpin
go
use zy
go
insert into tb_cpin values('E:/09.9zy1/images/tu1','饲料','500','350','来看一下啊！')
go

USE zy
GO
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='tb_news'AND TYPE='U')
DROP TABLE tb_news
GO
CREATE TABLE tb_news
(       
ID INT NOT NULL IDENTITY (1,1)PRIMARY KEY,
TITLE VARCHAR(100)NULL,
Names varchar(20)null,
Data DateTime  Not Null DEFAULT GetDate()
)
go
select *from tb_news
go
use zy
go
insert into tb_news values('最新消息','不知道',0)
go

 

USE zy
GO
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='tb_member'AND TYPE='U')
DROP TABLE tb_member
GO
CREATE TABLE tb_member
(       
ID INT NOT NULL IDENTITY (1,1)PRIMARY KEY,
UserName VARCHAR(100)NULL,
PasWord varchar(20)null,
Data DateTime  Not Null DEFAULT GetDate()
)
go
select*from tb_member
insert into tb_member values('丁丽琴','ggfhvbvbvclt',0)
insert into tb_member values('111','111',0)