-- 我知道一個(gè)值“White”，想知道它在哪個(gè)表里的哪個(gè)字段

-- 使用Northwind測(cè)試
USE Northwind
GO

DECLARE @what varchar(800)
SET @what='White'? --要搜索的字符串

DECLARE @sql varchar(8000)

DECLARE TableCursor CURSOR LOCAL FOR
SELECT sql='IF EXISTS ( SELECT 1 FROM ['+o.name+'] WHERE ['+c.name+'] LIKE ''%'+@what+'%'' ) PRINT ''所在的表及字段：['+o.name+'].['+c.name+']'''
FROM syscolumns c JOIN sysobjects o ON c.id=o.id
WHERE o.xtype='U' AND c.status>=0 AND c.xusertype IN (175, 239, 231, 167 )

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @sql
WHILE @@FETCH_STATUS=0
? BEGIN
??? EXEC( @sql )
??? FETCH NEXT FROM TableCursor INTO @sql
? END

CLOSE TableCursor

-- 刪除游標(biāo)引用
DEALLOCATE TableCursor

?

-- 測(cè)試結(jié)果
所在的表及字段：[Orders].[ShipName]
所在的表及字段：[Customers].[CompanyName]

?