The newbie was partially right, when I pasted the statements, it erred at

insert into a (b) values (1), (2), (3)

I am using SQL Server 2005. I dug around the Internet, and saw it is supposed to work with MySql and Sql Server 2008?

I got the answer right because the point was about rollback. Does everyone who answered right or wrong, will get half-points instead? :Whistling: