sql server 2012 数据库所有表里查找某字符串的方法

                                                                                 xtype = 175 or –char
                                                                                 xtype = 231 or –nvarchar
                                                                                 xtype = 239 or –nchar
                                                                                 xtype = 241 –xml
                                                                             )
     OPEN columnCursor;
     DECLARE @columnName NVARCHAR(MAX);
     FETCH NEXT from columnCursor INTO @columnName;
     WHILE @@fetch_status = 0
     BEGIN
         –4.在表的字段中，对每一行进行模糊搜索，并输出找到的信息。
         DECLARE @DynamicSQLText NVARCHAR(MAX) = ‘IF ( EXISTS ( SELECT * FROM [‘ + @tableName + ‘] WHERE [‘ + @columnName + ‘] LIKE ”%’ + @key_find + ‘%” ) ) BEGIN DECLARE @CurrentTableCount Bigint = ( SELECT COUNT(*) From [‘ + @tableName + ‘] ); PRINT ”Find : Table [‘ + @tableName + ‘], Column [‘ + @columnName + ‘], Row Count:” + CAST( @CurrentTableCount AS NVARCHAR(MAX) ) + ”.”;  END’;