Sorry - I'm not sure exactly how this relates to SQL Compare? If you want to order rows in a table by the date last modified, you'd need to set that up through SSMS - there's a little more information here that might be useful to you:
Ah, right, OK. SQL Server doesn't capture any information like this by default, so you'd need to set up a computed column for SQL Compare or SQL Data Compare to have any access to that information. I'm assuming this question is actually about SQL Data Compare, given that you're talking about sorting by columns.
If you've got that DateModified column set up, then you can filter the data with a WHERE clause as detailed on this page:
lkalman@financemgr.com
Posts: 30
Comments
http://stackoverflow.com/questions/2610 ... sql-server
Is that the kind of thing you're after?
Red Gate Technical Support Engineer
For Example if you are only looking to find out today's changes and not all other changes.
If you've got that DateModified column set up, then you can filter the data with a WHERE clause as detailed on this page:
http://www.red-gate.com/supportcenter/C ... Conditions
That ought to let you filter for changes applied within a specific timeframe. Does that help at all?
Red Gate Technical Support Engineer