This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Reto Egeter, fullparam.wordpress.com */ | |
| DECLARE @SearchStrTableName nvarchar(255), @SearchStrColumnName nvarchar(255), @SearchStrColumnValue nvarchar(255), @SearchStrInXML bit, @FullRowResult bit, @FullRowResultRows int | |
| SET @SearchStrColumnValue = '%searchthis%' /* use LIKE syntax */ | |
| SET @FullRowResult = 1 | |
| SET @FullRowResultRows = 3 | |
| SET @SearchStrTableName = NULL /* NULL for all tables, uses LIKE syntax */ | |
| SET @SearchStrColumnName = NULL /* NULL for all columns, uses LIKE syntax */ | |
| SET @SearchStrInXML = 0 /* Searching XML data may be slow */ |