lyfz_repos/经典版源码/document/数据库维护脚本/将截断字符串或二进制数据.sql

use db
--将截断字符串或二进制数据。
declare @maxlen int
select len(sex) from [client3] group by sex
select @maxlen = max(len(sex)) from [client3] 
select * from [client3] where len(sex) = @maxlen
--delete from client3 where len(sex) = @maxlen