sp_helptext输出错行问题解决

USE tempdb
GO

--创建测试存储过程
CREATE PROC dbo. Demo1
       @Length INT
AS
SET NOCOUNT ON
IF(@Length > 0 )
       PRINT ‘>0‘
ELSE
       PRINT ‘<=0‘

GO

--获取存储过程定义
DECLARE @ObjectName NVARCHAR( 50)
SET @ObjectName = N‘Demo1‘

SELECT ObjectDefinition =b. name FROM
(SELECT Content=CONVERT (XML, ‘<root><v><![CDATA[‘ + REPLACE(OBJECT_DEFINITION (OBJECT_ID( @ObjectName)), CHAR(13 )+CHAR( 10), ‘]]></v><v><![CDATA[‘ ) + ‘]]></v></root>‘)) a
OUTER APPLY
(SELECT [name] = C. v.value (‘.‘, ‘NVARCHAR(MAX)‘) FROM a.Content .nodes( ‘/root/v‘) C(v )) b

--直接拷贝结果
/*

--创建测试存储过程
CREATE PROC dbo.Demo1
      @Length INT
AS
SET NOCOUNT ON
IF(@Length > 0)
      PRINT ‘>0‘
ELSE
      PRINT ‘<=0‘

*/