没有此类搜索的系统表。鉴于您可以尝试此目的
DECLARE @ValueToSearch NVARCHAr(500)DECLARE @SearchColumn NVARCHAr(100)DECLARE @TableName NVARCHAr(200)DECLARE @ColumnName NVARCHAr(200)SET @ValueToSearch ='YOUR VALUE TP SEARCH'SET @SearchColumn = 'YOUR COLUMN'DECLARE @getResult CURSORSET @getResult = CURSOR FOR SELECt t.name AS table_name,c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERe c.name = @SearchColumn OPEN @getResult FETCH NEXT FROM @getResult INTO @TableName,@ColumnName WHILE @@FETCH_STATUS = 0 BEGIN SET NOCOUNT ON ; DECLARE @RESULT INT; DECLARE @TYPE INT DECLARE @QUERY NVARCHAr(1000) SET @QUERY = 'select @RESULT=count(*) from ' + ISNULL(@TableName,'') +' WHERe '+ ISNULL(@ColumnName,'')+'='''+ ISNULL(@ValueToSearch,'') +'''' EXEC sp_executesql @QUERY, N'@result int OUTPUT, @type int OUTPUT', @RESULT OUTPUT, @TYPE OUTPUT IF(ISNULL(@RESULT,0)>0) BEGIN SET NOCOUNT ON; SELECt ' COLUMN '+ @ColumnName + ' OF TABLE ' +@TableName+ ' HAS THIS VALUE.' END FETCH NEXT FROM @getResult INTO @TableName,@ColumnName ENDCLOSE @getResultDEALLOCATE @getResult
谢谢
马诺吉
