本语句适用于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
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