Browse by Tags

All Tags » search value (RSS)
14 December 2009 14:22

Search a value in character column of all tables

Sometimes, you may need to find a value in the characters columns (char, varchar, etc) in all the tables This is one of the methods to do it declare @sql varchar ( max ), @search varchar ( 100 ) set @sql = '' set @search = 'your search string'...
Posted by Madhivanan | with no comments
Filed under: , ,