1: CREATE TABLE tTest ( i INT )2: INSERT tTest ( i ) VALUES( 1 )3: INSERT tTest ( i ) VALUES( 1 )4: INSERT tTest ( i ) VALUES( 1 )5: INSERT tTest ( i ) VALUES( 1 )6:7: BEGIN TRAN8: TRUNCATE TABLE tTest9: SELECT * FROM tTest10: ROLLBACK11:12: SELECT COUNT(*) FROM tTest13: DROP TABLE tTest14:15:
So, yes - it is subject to the transaction; also - it is a logged operation, its just that the individual rows are not logged "individually" like they would if you used DELETE.
Post a Comment
Post a Comment