SQL Server 2005

[suarve]

Hi,

I have just stupidly forgot to include a where caluse in an sql statement. Now my sql has updated the whole table to the same information, so Im fairly scared now.

Is there a way to reverse this update? At the minute, I'm thinking I may need to go to my webhost and ask for a backup to be restored.

Many thanks

 

[suarve]

Phew phew phew!

Just noticed I had a tab open of the table, as of about 30 mins ago. As its only a category table (27 records) I was able to manually copy/paste the dat back in.

In my panic, just read about rollback transaction
when using stored procedures, so I guess that a good thing to use in the future.

/relief!