首页 新闻 赞助 找找看

在sql2000里面执行sql语句报错

0
悬赏园豆:10 [已解决问题] 解决于 2015-05-27 16:44
如题,这是报错信息   这个要怎么快速改对
服务器: 消息 170,级别 15,状态 1,行 9
第 9 行: '(' 附近有语法错误。
服务器: 消息 8103,级别 16,状态 1,行 1
表 'dbo.e_Version' 不存在,或无法为 SET 操作打开该表。
 
下面是sql脚本

USE [ceshi]
GO
/****** Object: Table [dbo].[e_website] Script Date: 05/27/2015 09:35:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_website](
[website_id] [nvarchar](50) NOT NULL,
[website_name] [nvarchar](100) NULL,
[keyword] [nvarchar](100) NULL,
[description] [nvarchar](500) NULL,
[template_url] [nvarchar](100) NULL,
[html_url] [nvarchar](100) NULL,
[needpermission] [int] NULL,
[needinenglish] [int] NULL,
[website_name_en] [nvarchar](100) NULL,
[keyword_en] [nvarchar](100) NULL,
[description_en] [nvarchar](500) NULL,
[template_en_url] [nvarchar](100) NULL,
[html_en_url] [nvarchar](100) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[e_website] ([website_id], [website_name], [keyword], [description], [template_url], [html_url], [needpermission], [needinenglish], [website_name_en], [keyword_en], [description_en], [template_en_url], [html_en_url]) VALUES (N'ehope', N'咖茶', N'咖茶', N'咖茶', N'', N'', 0, 0, N'', N'', N'', N'12', N'33')
/****** Object: Table [dbo].[e_Version] Script Date: 05/27/2015 09:35:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_Version](
[nid] [int] IDENTITY(1,1) NOT NULL,
[ncode] [int] NULL,
[ncontent] [nvarchar](2000) NULL,
[nbanqi] [int] NULL,
CONSTRAINT [PK_e_Version] PRIMARY KEY CLUSTERED
(
[nid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[e_Version] ON
INSERT [dbo].[e_Version] ([nid], [ncode], [ncontent], [nbanqi]) VALUES (1, 241, N'<p><img border="0" alt="" width="636" usemap="#PagePicMap" src="../images/1-1.jpg" /> <map name="pagepicmap">
<area shape="rect" coords="10,164,630,457" href="241_1.aspx?code=241&amp;bq=1&amp;id=24111" />
<area shape="rect" coords="10,463,422,697" href="241_1.aspx?code=241&amp;bq=1&amp;id=24112" />
<area shape="rect" coords="222,705,630,772" href="241_1.aspx?code=241&amp;bq=1&amp;id=24115" />
<area shape="rect" coords="425,461,631,698" href="241_1.aspx?code=241&amp;bq=1&amp;id=24113" />
<area shape="rect" coords="13,707,215,940" href="241_1.aspx?code=241&amp;bq=1&amp;id=24114" />
<area shape="rect" coords="224,778,627,938" href="241_1.aspx?code=241&amp;bq=1&amp;id=24115" /></map></p>', 1)
INSERT [dbo].[e_Version] ([nid], [ncode], [ncontent], [nbanqi]) VALUES (3, 241, N'<p><img border="0" width="635" usemap="#PagePicMap" alt="" src="../images/2-1.jpg" /> <map name="pagepicmap">
<area shape="rect" coords="6,54,418,170" href="RJNewspaper_list.aspx?code=241&amp;bq=2&amp;id=24121" />
<area shape="rect" coords="8,176,421,348" href="RJNewspaper_list.aspx?code=241&amp;bq=2&amp;id=24122" />
<area shape="rect" coords="430,54,621,343" href="RJNewspaper_list.aspx?code=241&amp;bq=2&amp;id=24123" />
<area shape="rect" coords="221,613,625,773" href="RJNewspaper_list.aspx?code=241&amp;bq=2&amp;id=24126" />
<area shape="rect" coords="224,360,621,609" href="RJNewspaper_list.aspx?code=241&amp;bq=2&amp;id=24124" />
<area shape="rect" coords="12,626,212,930" href="RJNewspaper_list.aspx?code=241&amp;bq=2&amp;id=24125" />
<area shape="rect" coords="225,779,621,929" href="RJNewspaper_list.aspx?code=241&amp;bq=2&amp;id=24127" /></map></p>', 2)
INSERT [dbo].[e_Version] ([nid], [ncode], [ncontent], [nbanqi]) VALUES (4, 242, N'
<img src="images/2-1.jpg" width=635 usemap=#PagePicMap border=0>
<map name=pagepicmap>
<area shape="rect" coords="12,452,510,671" href="RJNewspaper_list.aspx?code=242&amp;bq=1&amp;id=24213">
<area shape="rect" coords="521,247,622,444" href="RJNewspaper_list.aspx?code=242&amp;bq=1&amp;id=24212">
<area shape="rect" coords="12,688,200,920" href="RJNewspaper_list.aspx?code=242&amp;bq=1&amp;id=24215">
<area shape="rect" coords="208,691,510,917" href="RJNewspaper_list.aspx?code=242&amp;bq=1&amp;id=24216">
<area shape="rect" coords="523,451,625,671" href="RJNewspaper_list.aspx?code=242&amp;bq=1&amp;id=24214">
<area shape="rect" coords="12,158,514,442" href="RJNewspaper_list.aspx?code=242&amp;bq=1&amp;id=24211">
<area shape="rect" coords="523,679,624,920" href="RJNewspaper_list.aspx?code=242&amp;bq=1&amp;id=24217" /></map>
', 1)
INSERT [dbo].[e_Version] ([nid], [ncode], [ncontent], [nbanqi]) VALUES (6, 241, N'333344', 3)
INSERT [dbo].[e_Version] ([nid], [ncode], [ncontent], [nbanqi]) VALUES (7, 250, N'<p>dddd</p>', 1)
SET IDENTITY_INSERT [dbo].[e_Version] OFF
/****** Object: Table [dbo].[e_relatedcontents] Script Date: 05/27/2015 09:35:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

 

..00..的主页 ..00.. | 初学一级 | 园豆:49
提问于:2015-05-27 14:39
< >
分享
最佳答案
0

把CREATE TABLE [dbo].[e_Version](
[nid] [int] IDENTITY(1,1) NOT NULL,
[ncode] [int] NULL,
[ncontent] [nvarchar](2000) NULL,
[nbanqi] [int] NULL,
CONSTRAINT [PK_e_Version] PRIMARY KEY CLUSTERED 
(
[nid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

改为

CREATE TABLE [dbo].[e_Version](
[nid] [int] IDENTITY(1,1) NOT NULL,
[ncode] [int] NULL,
[ncontent] [nvarchar](2000) NULL,
[nbanqi] [int] NULL
) 就可以了

..00.. | 初学一级 |园豆:49 | 2015-05-27 16:43
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册