在sql2000里面执行sql语句报错
0
悬赏园豆：10
[已解决问题]
解决于 2015-05-27 16:44
如题，这是报错信息 这个要怎么快速改对
服务器: 消息 170，级别 15，状态 1，行 9
第 9 行: '(' 附近有语法错误。
服务器: 消息 8103，级别 16，状态 1，行 1
表 'dbo.e_Version' 不存在，或无法为 SET 操作打开该表。
第 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&bq=1&id=24111" />
<area shape="rect" coords="10,463,422,697" href="241_1.aspx?code=241&bq=1&id=24112" />
<area shape="rect" coords="222,705,630,772" href="241_1.aspx?code=241&bq=1&id=24115" />
<area shape="rect" coords="425,461,631,698" href="241_1.aspx?code=241&bq=1&id=24113" />
<area shape="rect" coords="13,707,215,940" href="241_1.aspx?code=241&bq=1&id=24114" />
<area shape="rect" coords="224,778,627,938" href="241_1.aspx?code=241&bq=1&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&bq=2&id=24121" />
<area shape="rect" coords="8,176,421,348" href="RJNewspaper_list.aspx?code=241&bq=2&id=24122" />
<area shape="rect" coords="430,54,621,343" href="RJNewspaper_list.aspx?code=241&bq=2&id=24123" />
<area shape="rect" coords="221,613,625,773" href="RJNewspaper_list.aspx?code=241&bq=2&id=24126" />
<area shape="rect" coords="224,360,621,609" href="RJNewspaper_list.aspx?code=241&bq=2&id=24124" />
<area shape="rect" coords="12,626,212,930" href="RJNewspaper_list.aspx?code=241&bq=2&id=24125" />
<area shape="rect" coords="225,779,621,929" href="RJNewspaper_list.aspx?code=241&bq=2&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&bq=1&id=24213">
<area shape="rect" coords="521,247,622,444" href="RJNewspaper_list.aspx?code=242&bq=1&id=24212">
<area shape="rect" coords="12,688,200,920" href="RJNewspaper_list.aspx?code=242&bq=1&id=24215">
<area shape="rect" coords="208,691,510,917" href="RJNewspaper_list.aspx?code=242&bq=1&id=24216">
<area shape="rect" coords="523,451,625,671" href="RJNewspaper_list.aspx?code=242&bq=1&id=24214">
<area shape="rect" coords="12,158,514,442" href="RJNewspaper_list.aspx?code=242&bq=1&id=24211">
<area shape="rect" coords="523,679,624,920" href="RJNewspaper_list.aspx?code=242&bq=1&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
最佳答案
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
) 就可以了
