title: Find the table name with the data value
body: <p>I am using SQL Server 2008 R2. Now I want to write a SQL statement to find the table name that an column of that table contains the word 'happy'. The column name <code>like '%abc'</code> may contains the word</p>
  
  <p>Can anyone give me some ideas?</p>
  
  <p>Thanks,
  V</p>