String output

[chintapalli]

Hi,

SQL Server 7.0 returns 256 characters of a table field with NVarChar 4000 length. Does anyone know why?

Here is the sample code:
****************************Code begins***************
CREATE PROCEDURE SQLLengthTest AS

DECLARE @STRtEST NVARCHAR(4000)

SET @STRtEST = 'HarishABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890abcdefgihjklmopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890abcdefgihjklmopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890abcdefgihjklmopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890abcdefgihjklmopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890abcdefgihjklmopqrstuvwxyz'

SELECT @STRtEST
--This returns full string length > 256 characters

CREATE TABLE #Test
(L NVARCHAR(4000))

INSERT INTO #Test VALUES(@STRtEST)

SELECT *
FROM #Test
--This returns string length = 256 characters only
***************************Code ends here**************

Thanks.

Harish.

 

[tlbroadbent]

If you are using SQL Query Analyzer, the default setting for maximum column length is 256. Open the QA Options, click on the results tab and change the value. It can be as large as 8000. (SQL 2000) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.