title: How to alter SQL in "Edit Top 200 Rows" in SSMS 2008
body: <p>In SQL Server 2008 Management Studio, when I right click on a database table and choose "<strong>Select Top 100 Rows</strong>", I can then e.g. easily add a "ORDER BY " statement to the SQL. That works <strong>fine</strong>.</p>
  
  <p>But when I do choose "<strong>Edit Top 200 Rows</strong>", I don't have the ability to <strong>alter</strong> the SQL (which makes it hard to find and edit a record just added in the 10,000 that are there.</p>
  
  <p>I am quite sure I was able to do this in <strong>SQL Server 2000</strong>.</p>
  
  <p><strong>Is there any way in SMSS 2008 to alter the way the records are displayed when editing records?</strong></p>