NuRoN Consulting, INC.

Blog > SQL Tools > Databases > Util > Procedures > dbo.PrintLargeText

Dependencies for Stored procedure: Util.dbo.PrintLargeText

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
Util.dbo.PrintLargeText	Stored procedure	Util.dbo.PrintLargeText_CLR	Assembly (CLR) stored-procedure	1	[Util].[dbo].[PrintLargeText_CLR]
Util.dbo.PrintLargeText_CLR	Assembly (CLR) stored-procedure	Util.UtilClr	ASSEMBLY	2	[Util].[dbo].[PrintLargeText_CLR], [Util].[UtilClr]

Stored procedure: Util.dbo.PrintLargeText

CREATE PROCEDURE dbo.PrintLargeText
    @Input VARCHAR(MAX),
    @RtrimLines BIT = 1
AS
SET NOCOUNT ON

IF LEN(@Input) > 0
    BEGIN
        IF LEN(@Input) <= 8000
            PRINT @Input
        ELSE
            BEGIN
                DECLARE @Printed BIT
                EXEC dbo.PrintLargeText_CLR
                    @Input,
                    @TrimMultiline = @RtrimLines,
                    @Printed = @Printed OUTPUT

                IF @Printed = 0
                    SELECT  1 AS tag,
                            NULL AS parent,
                            '

' + @Input + '

' AS [Q!1!Q!CDATA]
                    FOR     XML EXPLICIT,
                                TYPE

            END
    END

Description for Stored procedure: Util.dbo.PrintLargeText

Todo