karthik.nallajalla (2/1/2009)

---

REPLICATE( N'A', 4000000));

what is the meaning of N in N'A'? is it the maximum length.

I executed the below statements,

INSERT #t VALUES (1, REPLICATE( N'A', 4000000));
INSERT #t VALUES (2, REPLICATE( 'A', 4000000));

SELECT DATALENGTH(LongName) FROM #t

The result of the SELECT is
8000
16000

I don't know why i got 16000. Can anyone explain me?

Shaun McGuile (2/2/2009)

---

REPLICATE function is obviously broken then.

CREATE TABLE #t
         (ID int,
          LongName nvarchar(MAX));

INSERT #t
VALUES (1, REPLICATE(CAST(N'A' AS nvarchar(MAX)), 4000000));

SELECT DATALENGTH(LongName) FROM #t WHERE ID = 1;

Shaun McGuile (2/2/2009)

---

Hugo: so what you are saying is that REPLICATE uses varchar sizing i.e. 8000 and not the destination size unless you explicitly instruction the function to use something else as shown in your code. ;)

Dumb function ! :P

DECLARE @i1 int, @i2 int, @f1 float;
SET @i1 = 10;
SET @i2 = 3;

SET @f1 = @i1 / @i2;
SELECT @f1;