title: How to fetch row one by one in sql
body: <p>I am fetching table-names from particular database like this</p>
  
  <pre><code>SELECT name FROM sys.Tables where name like 'some pattern'
  
  Output : 
  Name
  sampletable_123,
  sampletable_456,
  sample_789.
  </code></pre>
  
  <p>It can return more than one row like above output. How to fetch row one by one?</p>
  
  <p>Because I want to find out column-name/date from obtained table-name. If date is less than current date, I want to drop that table.</p>
  
  <pre><code>select top 1 Udate from  sampletable_123
  where Udate &lt; convert(varchar(10),getdate(),101)
  
  delete table sampletable_123.
  </code></pre>
  
  <p>How to do that?</p>