Solomon, in my experience the "SELECT * FROM Table1 to test that change" approach is very inefficient. Come to think of it, next month or next year you will have to add some more test data for some other requirement, and that will break your "test that change" piece. It is much better to test exactly the change - the difference between the original and the modified states.
for large tables, if the table has an autoincremented id, you can do something like:
|query|select max(id) as top from table|
|top|
|>>currentmax|
// do your test here
|query|select * from table where id>@currentmax|
|col1|col2|col3|