129 ''''MaxLenUsed'''' AS MaxLenUsed,''''Sample Value '''' Sample, 130 131 ''''Comment '''' Comment INTO #tc FROM #t 132 133 134 135OPEN read_cursor 136 137 138 139FETCH NEXT FROM read_cursor INTO @tbl,@fld 140 141WHILE (@@fetch_status <> -1) --- failes 142 143BEGIN 144 145 IF (@@fetch_status <> -2) -- Missing 146 147 BEGIN 148 149 SET @sql=N''''SET @maxlen=(SELECT max(len(cast(''''+@fld+'''' as nvarchar))) FROM ''''+@tbl+'''')'''' 150 151 --PRINT @sql 152上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |