新建一个测试数据库 ms sql server 2005 版本上面的
建立新表
插入测试数据
创建一个测试的存储过程
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE test1
as
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT * from table_1
END
GO
接下来在2000下面也建立同名数据库
然后从2005 转 2000
然后在查询分析器里面执行查询
最后验证,数据导出的结果