UC知道SQL2005存储过程导出脚本到SQL2000
来源：百度知道 编辑：UC知道 时间：2024/07/05 23:54:04
SQL2005的存储过程导出脚本，选项选择SQL 2000了，但是在SQL2000里运行老是出错，就三个存储过程，谁帮看看，谢谢
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MonthSalesOutDate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[MonthSalesOutDate] AS
update [user] set DownLevel = 1,DownReason =DownReason+CONVERT(varchar(30),getdate(),23)+''省－市，月销量不足''
where getdate() > downdate and usertype=2 and level = ''省级代理''
update [user] set DownLevel = 1,DownReason =DownReason+CONVERT(varchar(30),getdate(),23)+''市－经销商，月销量不足''
where getdate() > downdate and usertype=2 and level ='' 市级代理''
'
END
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MonthSalesOutDate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[MonthSalesOutDate] AS
update [user] set DownLevel = 1,DownReason =DownReason+CONVERT(varchar(30),getdate(),23)+''省－市，月销量不足''
where getdate() > downdate and usertype=2 and level = ''省级代理''
update [user] set DownLevel = 1,DownReason =DownReason+CONVERT(varchar(30),getdate(),23)+''市－经销商，月销量不足''
where getdate() > downdate and usertype=2 and level ='' 市级代理''
'
END
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'
2000里没有sys.objects, 你吧出错错误的贴出来
2005导出的脚本在2000都可以运行的呀，除了一些特殊的2005定义的函数像Row_number之类。
你的把这3个存储过程中调用到的其他存储过程， 先执行下，然后再执行这3个存储过程。
如果还不行，那把错误信息，贴出来吧。
你导出的时候系统会让你选择，你很多东西都要设成FALSE，我以前就有遇到这样的问题