select name 字段名,长度=length from syscolumns where id =object_id(N'你要查询的表名.')
select * from tb_data_1_1 where picname in (select picname from tb_picture where user1='5447')怎么查询处 tb_data_1_1 中满足这个条件的总字符长度?
--用len函数求出每个字段的具体长度然后相加,for example: select len(字段1) + len(字段2)+ .... from tb_data_1_1 where picname in (select picname from tb_picture where user1='5447')
select len(字段1) + len(字段2)+ .... from tb_data_1_1 where picname in (select picname from tb_picture where user1='5447')