| @sql,N'@maxlen int OUTPUT',@maxlen OUTPUT
--print @maxlen
set @sql=N'set @sample=(select top 1 cast(' @fld ' as nvarchar) from ' @tbl ' where len(cast(' @fld ' as nvarchar))=' convert(nvarchar(5),@maxlen) ')'
exec SP_EXECUTESQL @sql,N'@sample varchar(30) OUTPUT',@sample OUTPUT
--for quickly
--set @sql=N'set @sample=convert(varchar(20),(select top 1 ' @fld ' from '
--@tbl ' order by 1 desc ))'
PRINT @sql
print @sample
print @tbl
exec SP_EXECUTESQL @sql,N'@sample nvarchar(30) OUTPUT',@sample OUTPUT
insert into #tc select *,ltrim(isnull(@maxlen,0)) as MaxLenUsed,
convert(nchar(20),ltrim(isnull(@sample,' '))) as Sample,' ' Comment from #t where TableName=@tbl and FieldName=@fld
end
|
| 共16页: 上一页 [1] [2] [3] 4 [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] 下一页 |
评论加载中…
