Only printing 8000 characters after using varchar(max) instead of max(8000)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Omendra
    New Member
    • Mar 2011
    • 4

    Only printing 8000 characters after using varchar(max) instead of max(8000)

    Hi,I am creating my SP as dynamic,
    On that i am defining varchar(max) to need to get more than 8000 characters.

    But my SP is taken only 8000 characters when i am doing Print to my SP.

    Please help how to got All

    SP for Reference -

    ALTER PROC [dbo].[spEditorReport_ Test]
    ( @PJID VARCHAR(20),
    @Pstartdate VARCHAR(50),
    @Penddate VARCHAR(50),
    @PEditorId VARCHAR(100),
    @IsDateAssigned BIT

    )
    AS
    BEGIN
    SET nocount ON
    DECLARE @jid VARCHAR(20),
    @StartDate VARCHAR(50),
    @endDate VARCHAR(50),
    @DBName VARCHAR(20),
    @Query VARCHAR(MAX)

    SET @DBName = 'nature'
    SET @Query = 'DECLARE @jid AS VARCHAR(20),
    @StartDate AS VARCHAR(50),
    @endDate AS VARCHAR(50),
    @DBName As NVARCHAR(50),

    ............... ............... ........
    ............... ............... ........
    (Having Big Length)
    ............... ............... ........
    ............... ............... ........

    print (@Query)
    exec (@Query)
    END


    Output: Only printing 8000 characters like -

    DECLARE @jid AS VARCHAR(20),
    @StartDate AS VARCHAR(50),
    @endDate AS VARCHAR(50),
    @DBName As NVARCHAR(50),

    @PEditorId AS NVARCHAR(2000),
    @IsDateAssigned BIT

    ............... . (Till 8000 char, rest it leaves)


    Please tell me how can i print all characters.
Working...