订阅根據SQL存儲過程名取得存儲過程的內容：
示例如下：（此語句適用于SQL Server2000/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
陝西省紀委監委日前通報了4起在曆史文化遺産保護中失職失責的典型案例
沙特女性獲“新權”：不用再和男性分開用餐
南昌公園發生命案
臨近國慶，李小璐與女兒在天安門前合影
