sort by Date Last Modified

lkalman@financemgr.comlkalman@financemgr.com Posts: 30
edited September 13, 2012 9:51AM in SQL Compare Previous Versions
Looking to add a column on the object to be able to
sort by Date Last Modified
· Share on Twitter

Comments

  • Andy C SAndy C S Posts: 173
    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:

    http://stackoverflow.com/questions/2610 ... sql-server

    Is that the kind of thing you're after?
    Andy Campbell Smith

    Red Gate Technical Support Engineer
    · Share on Twitter
  • lkalman@financemgr.comlkalman@financemgr.com Posts: 30
    Well this way you can sort by date order and determine which change you want per date.

    For Example if you are only looking to find out today's changes and not all other changes.
    · Share on Twitter
  • Andy C SAndy C S Posts: 173
    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:

    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?
    Andy Campbell Smith

    Red Gate Technical Support Engineer
    · Share on Twitter
Sign In or Register to comment.