declare @colname varchar(100)
declare cu_cname cursor for
select name from syscolumns where id=object_id('SH_data_1_ok')
open cu_cname
fetch next from cu_cname into @colname
while @@fetch_status=0
begin
exec ('select '''+@colname+''' as columnname,max from (select max(len(['+ @colname+'])) as max from SH_data_1_ok) as a')
declare cu_cname cursor for
select name from syscolumns where id=object_id('SH_data_1_ok')
open cu_cname
fetch next from cu_cname into @colname
while @@fetch_status=0
begin
exec ('select '''+@colname+''' as columnname,max from (select max(len(['+ @colname+'])) as max from SH_data_1_ok) as a')
fetch next from cu_cname into @colname
end
close cu_cname
deallocate cu_cname
end
close cu_cname
deallocate cu_cname