User Profile

Omendra · Apr 4 '11, 06:14 AM

Hi,

I had a VARCHAR(MAX) parameter declared in my stored procedure and trying to concatenat single column from a table which has 1500 rows into a string and keep in this variable, if i am not mistaken, i read that the VARCHAR(MAX) can hold up to 2GB of data, so it make me so confuse that why the variable which i declared as MAX size, can only hold up 8000 characters, any idea? Please help me????

Omendra · Mar 31 '11, 10:31 AM

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...

Omendra · Mar 31 '11, 06:20 AM

Hi, I am using SQL Server 2005 and i am using Stored Procedure something like :-

I am getting error:-
Msg 170, Level 15, State 1,
Line 18: Incorrect syntax near 'MAX'.

DECLARE @jid AS VARCHAR(20),
@DBName As VARCHAR(50),
@Query AS VARCHAR(MAX)

SET @DBName = 'test'

SET @Query = '

DECLARE @jid...

Omendra · Mar 30 '11, 06:25 AM

I am getting an error When i am going to convert my SP as dynamic

Error :
Msg 403, Level 16, State 1, Line 21
Invalid operator for data type. Operator equals add, type equals text.

Code :

CREATE TABLE [dbo].[StudentComments] (

@Query AS VARCHAR(1000)
@DBName As NVARCHAR,

SET @DBName = 'test'
)

@Query = 'SELECT DISTINCT...

User Profile

Profile Sidebar

VARCHAR(MAX) only contains 8000 characters?, Need more than 8000

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

Getting error :- Msg 170, Level 15, State 1, Line 18: Incorrect syntax near 'MAX'.

Getting an error When i am going to convert my SP as dynamic