根据SQL存储过程名取得存储过程内容

本语句适用于MS SQL SERVER 2000/2005

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

--     GetContentByProcedureName '[dbo].[存储过程名]'
Create procedure GetContentByProcedureName
(@ProcedureName nvarchar(500))
as

if exists (select * from dbo.syscomments where id=object_id(N''+@ProcedureName+''))
select c.text, c.encrypted, c.number, xtype=convert(nchar(2), o.xtype),   
 datalength(c.text), convert(varbinary(8000), c.text), 0 from dbo.syscomments c, dbo.sysobjects o  
  where o.id = c.id and c.id = object_id(N''+@ProcedureName+'')
order by c.number, c.colid option(robust plan)

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

本文来自优快云博客，转载请标明出处：http://blog.youkuaiyun.com/downmoon/archive/2007/09/30/1807332.aspx