mysql查询含有某个值的表,sql查询数据库中有某个值的全部表

CREATE PROCEDURE dbo.FindString

@string NVARCHAR(100)

AS

DECLARE @SQL NVARCHAR(4000);

SET @SQL = N'

DECLARE @str NVARCHAR(4000);

SELECT

@str = ISNULL(@str + N'' OR '' + c.name + N'' LIKE N''''%'

+ @string + ' %'''''',

c.name + N'' LIKE N''''%' + @string +'%'''''') FROM syscolumns AS c JOIN systypes AS t ON c.id=OBJECT_ID(''?'')

AND c.xtype=t.xtype

AND t.name IN(''varchar'',''char'',''nvarchar'',''nchar'');

SET @str = ''SELECT TOP 1 1 FROM ? WHERE ''+@str;

CREATE TABLE #tb(a int);

INSERT #tb(a) EXEC(@str);

IF EXISTS(SELECT * FROM #tb)

PRINT ''?''

';

EXEC sp_MsforeachTable @SQL;

GO

别人写的一个存储过程的例子，看看对你有没有用...

取消

评论