在用SQL语法导入数据库的时候,提示:
服务器: 消息 208,级别 16,状态 1,行 1
对象名 'guest' 无效。
求解决,在线等
***********************************
补充:SQL代码
create database myBoard
go
use myBoard
create table [guest]
(
ID int identity(1,1) primary key,
userName varchar(20) not null,
sex varchar(10) not null,
url varchar(20),
qq varchar(20),
email varchar(20),
content varchar(1000) not null,
reply varchar(1000),
postTime datetime default(getdate()),
imageUrl varchar(20) not null,
faceUrl varchar(20) not null
)
drop table [guest]
insert into [guest](userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic1.gif','face1.gif')
insert into [guest](userName,sex,content,imageUrl,faceUrl) values('wbuild','女','我是帅哥','pic2.gif','face2.gif')
insert into [guest](userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic3.gif','face3.gif')
insert into [guest](userName,sex,content,imageUrl,faceUrl) values('wbuild','女','我是帅哥','pic4.gif','face4.gif')
insert into [guest](userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic5.gif','face5.gif')
insert into [guest](userName,sex,content,imageUrl,faceUrl) values('wbuild','女','我是帅哥','pic6.gif','face6.gif')
insert into [guest](userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic7.gif','face7.gif')
insert into [guest](userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic8.gif','face8.gif')
select * from [guest]
drop table admin
create table admin
(
adminName varchar(20) not null,
adminPwd varchar(20) not null,
total varchar(20)
)
[ 本帖最后由 ssmceo 于 2009-5-19 15:41 编辑 ]
作者: ssmceo
发布时间: 2009-05-19