代码改变世界

if exists

2016-06-15 15:40  FingalZhu  阅读(133)  评论(0编辑  收藏  举报

use master
if exists(select *from sysdatabases where name='Images' )
drop database Images
go
create database Images
go
use Images
go
create table image
(
   imageId int primary key identity,
   imageName varchar(50),
)
go
insert into image values('200809031500_login_bg.jpg')
insert into image values('bg.gif')
insert into image values('FangKuai.gif')
insert into image values('TYJY_001011.jpg')
insert into image values('1.jpg')
insert into image values('2.jpg')