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.