在SQLServer2000中按照Byte计算字符串长度

function StorePage() { d=document; t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():''); void(keyit=window.open('http://www.365key.com/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=475,height=575,left=75,top=20,status=no,resizable=yes')); keyit.focus(); }

把以下脚本直接Copy执行就可以

CREATE Function GetByteLength(@a varchar(2000))
Returns INT
As
/*
功能描述：获取 函数混排字符串的字节长度.
参数：@a中英文数字混排字符串
返回：参数的字节长度
作者：王海波 2004-10-14
*/
Begin
Declare @i int,@len int

Set @i=1
Set @len=0

While @i<=len(@a)
Begin
IF Ascii(substring(@a,@i,1))>128 ---判断是否是AscII字符，如果不是加2，是则加1
Set @len=@len+2
Else
Set @len=@len+1
Set @i=@i+1
End
Return @len
End