Sometimes it’s the smallest enhancements… INSERT INTO has gotten a small makeover in SQL Server 2008 which now allows you to specify multiple rows as part of a single statement. While the sky has yet to fall in reaction to this, it’s a great little enhancement for people generating data insert scripts so that the data can be inserted as a single statement (rather than having to batch it all together), and I was surprised how many people commented to me after my TechEd session about how they loved this change :)
To make use of it, simple append addition rows in a comma delimited format, surrounding each row set in brackets.
e.g.
insert into Product values
(1, 'XBOX 360', 100),
(2, 'Black Zune', 100),
(3, 'Windows Server 2008', 100),
(4, 'SQL Server 2008', 100),