使用management studio 直接UI操作。 在产生脚本的选项当中 ,有一项产生删除的脚本。把它设为true就行了。
先drop到脚本 USE [1] GO /****** 对象: StoredProcedure [dbo].[UP_Analyze_Chart] 脚本日期: 02/06/2009 08:30:30 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UP_Analyze_Chart]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[UP_Analyze_Chart]在create到脚本USE [1] GO /****** 对象: StoredProcedure [dbo].[UP_Analyze_Chart] 脚本日期: 02/06/2009 08:30:18 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create procedure [dbo].[UP_Analyze_Chart] AS BEGIN select * from t_analysecharttype; END
在产生脚本的选项当中 ,有一项产生删除的脚本。把它设为true就行了。
GO
/****** 对象: StoredProcedure [dbo].[UP_Analyze_Chart] 脚本日期: 02/06/2009 08:30:30 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UP_Analyze_Chart]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[UP_Analyze_Chart]在create到脚本USE [1]
GO
/****** 对象: StoredProcedure [dbo].[UP_Analyze_Chart] 脚本日期: 02/06/2009 08:30:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[UP_Analyze_Chart]
AS
BEGIN
select * from t_analysecharttype;
END