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