[dba-SQLServer] varchar limits

David Emerson davide at dalyn.co.nz
Mon May 24 17:59:08 CDT 2004


SQL2000.

I have the following declaration in a stored procedure -

         declare @qs varchar(8000)

However, when I assign a string to the variable it seems to truncate at 
4000 characters.  My understanding is that varchar can have up to 8000 
characters.  Is there something I am missing?

Regards

David Emerson
Dalyn Software Ltd
25 Cunliffe St, Churton Park
Wellington, New Zealand
Ph/Fax (04) 478-7456
Mobile 027-280-9348 


More information about the dba-SQLServer mailing list