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