SET QUOTED_IDENTIFIER ON GOSET 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)GOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GO