将BlogEngine中的SQL2005的SQL installation script转换成SQL2000

最新推荐文章于 2025-09-11 20:53:34 发布

转载最新推荐文章于 2025-09-11 20:53:34 发布 · 56 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/dugoogle/archive/2007/11/10/955078.html

文章标签：

#数据库

本文记录了作者使用BlogEngine搭建博客过程中遇到的问题及解决方案，主要介绍了如何解决SQL2005安装脚本与SQL2000不兼容的问题。

最近想做个blog,可是从头开始又太麻烦,最好决定找一个源码来修改,于是在 www.asp.net上找到了 BlogEngine,觉得还比较适合我学习研究,于是下载下来,结果发现他用的是SQL2005,可我只有SQL2000,但他提供的 SQL installation script在SQL2000中运行会出现错误,如下:

Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'max'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'be_Settings'.

The tables that contain (max) are:
be_Pages
be_PostComment
be_Posts
be_Settings

应该是应为数据库不同而造成的,后来在论坛上找到了解决方法,
1.去除 SQL installation script中所有的
WITH (IGNORE DUPKEY = OFF) ON [PRIMARY]
2.将[varchar](max) 用ntext替换

以下是SQL2005与SQL2000中script的不同比较:

--SQL 2005
CREATE TABLE [dbo].[Table1]
(
[Field1] [int] IDENTITY(1,1) NOT NULL,
[Field2] [varchar(max)] NULL,
CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED
(
[Field1] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

--SQL 2000
CREATE TABLE [dbo].[Table1]
(
[Field1] [int] IDENTITY(1,1) NOT NULL,
[Field2] [ntext] NULL,
CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED
(
[Field1] ASC
)WITH IGNORE_DUP_KEY = OFF
) ON [PRIMARY]

这是原文地址:
http://www.codeplex.com/blogengine/Thread/View.aspx?ThreadId=12814
http://www.codeplex.com/blogengine/Thread/View.aspx?ThreadId=17608

转载于:https://www.cnblogs.com/dugoogle/archive/2007/11/10/955078.html