set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go-- =============================================
-- Author: 高利军
-- Create date: 2011-06-08
-- Description: 获取所有存储过程源码
-- =============================================
ALTER PROCEDURE [dbo].[sp_getAllProcText]
-- Add the parameters for the stored procedure here
AS
SET XACT_ABORT ON
BEGIN TRANSACTION
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
SET NOCOUNT ON;
declare @proc_text varchar(max)
DECLARE get_proc_text_cursor CURSOR FOR
SELECT 'IF OBJECT_ID(N'''+ [name] +''') IS NOT NULL '+ CHAR(10) + CHAR(13) +' DROP PROC ' + [name] + CHAR(10) + CHAR(13) + ' GO ' + CHAR(10) + CHAR(13) + definition + CHAR(10) + CHAR(13) +' GO'
FROM sys.sql_modules
inner join sysobjects on sys.sql_modules.object_id = sysobjects.id and type='p'
OPEN get_proc_text_cursor
FETCH NEXT FROM get_proc_text_cursor
INTO @proc_text
WHILE @@FETCH_STATUS = 0
BEGIN
--UPDATE tb_HQ_Out_Order SET state = 0 WHERE hoor_code = @hoor_code
print @proc_text
FETCH NEXT FROM get_proc_text_cursor
INTO @proc_text
END
CLOSE get_proc_text_cursor
DEALLOCATE get_proc_text_cursor
END
COMMIT TRANSACTION
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步