What is new in SQL Server 2008 aka Katmai
Multiple Inserts using the Insert Into Values enhancement in SQL Server 2008
Multiple Inserts using the Insert Into Values enhancement in SQL Server 2008
It is simple but effective to use the new Insert Into syntax if you use
insert multiple records into a table in one process using t-sql statements.
Here is a sample for you to try the newly introduced enhancement with SQL2008
in t-sql Insert Into command.
CREATE TABLE MultipleInsertsCities (
CityId int,
CityName nvarchar(25)
)
GO
INSERT INTO MultipleInsertsCities VALUES (1, N'Eskisehir'), (2, N'Istanbul')
SELECT * FROM MultipleInsertsCities
GO
INSERT INTO MultipleInsertsCities (CityId, CityName) VALUES (3, N'New York'), (4, N'Tokyo')
SELECT * FROM MultipleInsertsCities
GO
INSERT INTO MultipleInsertsCities (CityName) VALUES (N'Bangkok'), (N'Lima')
SELECT * FROM MultipleInsertsCities
GO
|