0

I have "Order" table with more than 5,000 records. When I ran the update query unfortunately I forgot to give the ‘where’ condition. Now the Date column in all the records has been updated. Is it possible to retrieve my existing column values. Example:

Update Order 
set ordered = getdate() 
where Cusid=50

(here I forget to mention the where condition).

user3073184
  • 77
  • 1
  • 11
RickyRam
  • 181
  • 1
  • 1
  • 10
  • possible duplicate of [Howto undo a SQL Server update command?](http://stackoverflow.com/questions/4691574/howto-undo-a-sql-server-update-command) – Alexander Mar 11 '14 at 09:42
  • The thing is I don't have a backup? – RickyRam Mar 11 '14 at 09:44
  • Maybe this [documentation](http://msdn.microsoft.com/en-us/library/ms179451.aspx) might help. Why don't you do backups? – Alexander Mar 11 '14 at 10:00
  • Thats why I alwaysssssssssssssssssssssss wrap my updates and deletes inside a `BEGIN TRAN.... COMMIT TRAN` block. – M.Ali Mar 11 '14 at 10:03

1 Answers1

0

I am afraid NO, cause the update has already been committed. Unless you have a backup of the table it's no more can be undone.

Rahul
  • 76,197
  • 13
  • 71
  • 125