有没有办法在Microsoft SQL Server中的每个表的每个字段中找到特定值？

SELECT employee_id, employee_name
FROM employees
WHERE employee_name = 'John';

DECLARE @SearchValue NVARCHAR(100) = 'example';
DECLARE @TableName NVARCHAR(100);
DECLARE @ColumnName NVARCHAR(100);
DECLARE @SQL NVARCHAR(MAX) = '';

DECLARE search_cursor CURSOR FOR
SELECT c.name AS ColumnName, t.name AS TableName
FROM sys.columns c
INNER JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.system_type_id IN (35, 99, 167, 175, 231, 239) -- 可以根据需要调整数据类型

OPEN search_cursor;

FETCH NEXT FROM search_cursor INTO @ColumnName, @TableName;

WHILE @@FETCH_STATUS = 0
BEGIN
    SET @SQL = @SQL + 'SELECT ''' + @TableName + ''' AS TableName, ''' + @ColumnName + ''' AS ColumnName FROM ' + @TableName + ' WHERE ' + @ColumnName + ' = ''' + @SearchValue + ''';';

    FETCH NEXT FROM search_cursor INTO @ColumnName, @TableName;
END

CLOSE search_cursor;
DEALLOCATE search_cursor;

EXEC sp_executesql @SQL;