1.可用sql server 2005 自带的工具生成2000数据库,同时在选择时注意要选择2000,注意先要删除多余的信息,比如存储过程, 等信息
2.生成表内容时,用相应的工具可生成其.sql 文件,注意生成文件中有些冗余信息,需要删除
3.在其应用到C#中可能遇到问题,ROW_NUMBER 不可知函数,
其解决办法:改写其函数,
如:
sql 2005中:
SELECT *
FROM
(SELECT *,ROW_NUMBER() OVER (ORDER BY [ArticleId] ASC)AS ROWNUMBER
FROM [Article]
) AS RESULT
WHERE ROWNUMBER BETWEEN 1 AND 14
SQL 2000:
CREATE TABLE RowNumber (
RowNumber int IDENTITY (1, 1),
_id char(9) )
INSERT RowNumber (_id)
SELECT ArticleId
FROM Article WHERE (ArticleClassId=51 or ArticleClassId=52)
SELECT *
FROM RowNumber JOIN [Article]
ON RowNumber._id = [Article].ArticleId
where RowNumber Between 1 and 14 ORDER BY [ArticleId] ASC
DROP TABLE RowNumber