How to retrieve all record from every table where id = 1 in MS SQL Server 2008 R2
<p>How do I retrieve all record from every table (Ex: table1, table2, table3, ... tableN ) where id = 1 from single database (EX: database1) in SQL Server 2008 R2?</p>

<p>Let's suppose I have 1 database and in that I have infinite tables (EX. table1,table2, ....,tableN). Is this possible to get all the record from entire database where id=1 on each table? I think it is possible with SQL <code>information_schema.table</code> or <code>information_schema.column</code>, but I don't know how to use this.</p>

<p>Any help appreciated</p>

<p>Thanks in advance!</p>