Generates SQL (SQL Server 2000) for searching all text columns for a given string. (Need to remove last UNION) Good for catching SQL injection results.

search-text-columns-mssql2000.sql

SELECT 
'select ' + column_name + ' as txt, 
''' + column_name + ''' as [column_name], 
id  from applications where ' + column_name + ' like ''%payday%'' union '

FROM INFORMATION_SCHEMA.COLUMNS
 
where table_name = 'applications'
and data_type in ('nvarchar','varchar','char','nchar')