title: Find specific row data in all database tables? Without Creating A Procedure Or Table
body: <p>This is what I have so far to find all tables with more than 100 rows: </p>
  
  <pre><code>SELECT sc.name +'.'+ ta.name TableName
   ,SUM(pa.rows) RowCnt
   FROM sys.tables ta
   INNER JOIN sys.partitions pa
   ON pa.OBJECT_ID = ta.OBJECT_ID
   INNER JOIN sys.schemas sc
   ON ta.schema_id = sc.schema_id
   WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0) AND pa.rows &gt;100 
   GROUP BY sc.name,ta.name,pa.rows
   ORDER BY TABLENAME
  </code></pre>
  
  <p>Is there something similar where I can go through the database to find out a specific row data for a column within a table? </p>
  
  <p>For example: 
           Where c.name = GUITARS and GUTARS = 'Fender'</p>
  
  <p>Edit: 
  I do not have CREATE PROCEDURE permission OR CREATE TABLE</p>
  
  <p>Just looking for any specific data under a certain column name, doesn't matter if it returns a lot of rows. </p>