sql server 2000中cast转化长度限制 cast字符截断

cast转化字符串时，如果没有声明varchar的长度，则会自动截断30个字符后面的字符

 

declare @aa varchar(800), @bb varchar(800)

set @aa = 'MaaaaaaaaaaaaaaaaaaaM SDaaaaaaaaaaaaaaaaaaaaaaaaB'
set @bb = cast(@aa as varchar) 
print @bb

结果:

MaaaaaaaaaaaaaaaaaaaM SDaaaaaa

 

需要

declare @aa varchar(800), @bb varchar(800)

set @aa = 'MaaaaaaaaaaaaaaaaaaaM SDaaaaaaaaaaaaaaaaaaaaaaaaB'
set @bb = cast(@aa as varchar(800)) 
print @bb

结果:

MaaaaaaaaaaaaaaaaaaaM SDaaaaaaaaaaaaaaaaaaaaaaaaB