>
172
173 EXEC SP_EXECUTESQL @sql,N''''@sample nvarchar(30) OUTPUT'''',@sample OUTPUT
174
175 INSERT INTO #tc SELECT *,ltrim(ISNULL(@maxlen,0)) as MaxLenUsed,
176
177 convert(nchar(20),ltrim(ISNULL(@sample,'''' ''''))) as Sample,'''' '''' Comment FROM #t where TableName=@tbl and FieldName=@fld
178
179 END
180
181 FETCH NEXT FROM read_cursor INTO @tbl,@fld
182
183END
184
185
186
187CLOSE read_cursor
188
189DEALLOCATE read_cursor
190
191GO
192
193
194
195SET ANSI_NULLS ON
上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |
