equivalent of flashback database/table to timestamp<br /> to_timestamp ('12/31/2003 22:45:00,'mm/dd/yyyy hh24:mi<img src='/community/emoticons/emotion-7.gif' alt=':s' />s');<br /> in sql server .
Where do you want to show data? If you use front end application,use format function there Or read about convert function in sql server help file Madhivanan Failing to plan is Planning to fail
I'm not entirely sure as I don't know Oracle that much. However I think he is asking how he can roll back to a previous state before issuing some UPDATE statement. If so, then SQL Server is a bit different from Oracle. There is no built-in support for such roll-back. One way would be to restore the db to that given point in time before the UPDATE was issued. However, in most cases this cannot be done as all modification since then will be lost. Probably the best bet, would be to use a third-party tool such as ApexSQL Log that can undo data modifications via incidental UPDATE statements. -- Frank Kalis Microsoft SQL Server MVP Contributing Editor, Writer & Forum Moderatorhttp://www.sql-server-performance.com Webmaster:http://www.insidesql.de
