Just need verification on something here.<br><br>If using a query like [INSERT INTO table1 (...) SELECT ... FROM table2 ...], will Sql Server rollback if an error is ...