VARCHAR(MAX)


Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58

VARCHAR(MAX),它的最大长度可以达到2G
注意:VARCHAR和VARCHAR(MAX)混在一起做处理时还是会变成VARCHAR,从而可能被截断,所以需要全转成VARCHAR(MAX)

DECLARE @ControlAccountS VARCHAR(MAX)
SET @ControlAccountS = ”
SET @ControlAccountS = REPLICATE(CONVERT(VARCHAR(MAX),’b’),8500)
PRINT LEN(@ControlAccountS)