<blockquote> <p>CREATE PROC SearchAllTables</p> <p><br /> (<br /> @SearchStr nvarchar(100)<br /> )<br /> AS<br /> BEGIN<br /> CREATE TABLE #Results (TableName NVARCHAR(370),ColumnName nvarchar(370), ColumnValue nvarchar(3630))</p> <p>SET NOCOUNT ON</p> <p>DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)<br /> SET @TableName = &#39;&#39;<br /> SET @SearchStr2 = QUOTENAME(&#39;%&#39; + @SearchStr + &#39;%&#39;,&#39;&#39;&#39;&#39;)</p> <p>WHILE @TableName IS NOT NULL<br /> BEGIN<br /> SET @ColumnName = &#39;&#39;<br /> SET @TableName =<br /> (<br /> SELECT MIN(QUOTENAME(TABLE_SCHEMA) + &#39;.&#39; + QUOTENAME(TABLE_NAME))<br /> FROM INFORMATION_SCHEMA.TABLES<br /> WHERE TABLE_TYPE = &#39;BASE TABLE&#39;<br /> AND QUOTENAME(TABLE_SCHEMA) + &#39;.&#39; + QUOTENAME(TABLE_NAME) &gt; @TableName<br /> AND OBJECTPROPERTY(<br /> OBJECT_ID(<br /> QUOTENAME(TABLE_SCHEMA) + &#39;.&#39; + QUOTENAME(TABLE_NAME)<br /> ), &#39;IsMSShipped&#39;<br /> ) = 0<br /> )</p> <p>WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)<br /> BEGIN<br /> SET @ColumnName =<br /> (<br /> SELECT MIN(QUOTENAME(COLUMN_NAME))<br /> FROM INFORMATION_SCHEMA.COLUMNS<br /> WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)<br /> AND TABLE_NAME = PARSENAME(@TableName, 1)<br /> AND DATA_TYPE IN (&#39;char&#39;, &#39;varchar&#39;, &#39;nchar&#39;, &#39;nvarchar&#39;)<br /> AND QUOTENAME(COLUMN_NAME) &gt; @ColumnName<br /> )</p> <p>IF @ColumnName IS NOT NULL<br /> BEGIN<br /> INSERT INTO #Results<br /> EXEC<br /> (<br /> &#39;SELECT &#39;&#39;&#39; +@TableName+ &#39;&#39;&#39;, &#39;&#39;&#39; + @TableName + &#39;.&#39; + @ColumnName + &#39;&#39;&#39;, LEFT(&#39; + @ColumnName + &#39;, 3630)<br /> FROM &#39; + @TableName + &#39; (NOLOCK) &#39; +<br /> &#39; WHERE &#39; + @ColumnName + &#39; LIKE &#39; + @SearchStr2<br /> )<br /> END<br /> END<br /> END</p> <p>SELECT * FROM #Results</p> <p>END</p> </blockquote> <p>Örnek kullanım&nbsp;</p> <blockquote> <p>exec SearchAllTables TESLİMATŞART1</p> </blockquote> <p>Alıntıdır :&nbsp;<a href="https://www.ozgurguler.net/blog/sql-veritabani-tum-tablokolon-ve-iceriklerde-arama-yapmak/">https://www.ozgurguler.net/blog/sql-veritabani-tum-tablokolon-ve-iceriklerde-arama-yapmak/</a></p>