deepinthecode.com
SQL Script to Find Text in all Database Tables and Views…Revised! Again! - Deep in the Code
The SQL script below, which modifies one I wrote last year, has been modified to work with SQL Server 2008 and newer versions. On these versions, when querying SQL Server to output the schema of a database table, length values of MAX are returned as -1. Since this script builds table variables that mimic the … Continue reading "SQL Script to Find Text in all Database Tables and Views…Revised! Again!"
David Young