查找字段类型为ntext或者text的列

 declare @colName nvarchar(50), @tblName nvarchar(50)
declare @colValue nvarchar(2000)

DECLARE objCursor CURSOR FOR
 select a.name, b.name
 from syscolumns a
 inner join sysobjects b on a.id=b.id and b.xtype='u'
 inner join systypes c on a.xtype = c.xtype and (c.name='ntext' or c.name='text')
OPEN objCursor
FETCH NEXT FROM objCursor INTO @colName,@tblName
WHILE @@FETCH_STATUS = 0
BEGIN
 print('select top 1 @colValue=' + @colName + ' from ' + @tblName)
 --exec('select top 1 @colValue=' + @colName + ' from ' + @tblName)
   FETCH NEXT FROM objCursor INTO @colName,@tblName
END
CLOSE objCursor
DEALLOCATE objCursor