153 EXEC SP_EXECUTESQL @sql,N''''@maxlen int OUTPUT'''',@maxlen OUTPUT
154
155 --print @maxlen
156
157 SET @sql=N''''SET @sample=(SELECT TOP 1 cast(''''+@fld+'''' as nvarchar) FROM ''''+@tbl+'''' WHERE len(cast(''''+@fld+'''' as nvarchar))=''''+convert(nvarchar(5),@maxlen)+'''')''''
158
159 EXEC SP_EXECUTESQL @sql,N''''@sample varchar(30) OUTPUT'''',@sample OUTPUT
160
161 --for quickly
162
163 --SET @sql=N''''SET @sample=convert(varchar(20),(SELECT TOP 1 ''''+@fld+'''' FROM ''''+
164
165 --@tbl+'''' order by 1 desc ))''''
166
167 PRINT @sql
168
169 print @sample
170
171 print @tbl上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |
