Sunday, September 30, 2007

I love this feature in SS 2008 - Insert Multiple Rows

SQL Server 2000/2005:

INSERT dbo.Brand(BrandName) VALUES (‘Pepsi’)

INSERT dbo.Brand(BrandName) VALUES (‘Oracle')

INSERT dbo.Brand(BrandName) VALUES (‘Microsoft')

INSERT dbo.Brand(BrandName) VALUES (‘Nissan')

SQL Server 2008:

INSERT dbo.Brand(BrandName)VALUES (‘Pepsi’),(‘Oracle'), (‘Microsoft'), (‘Nissan')

Labels: ,

0 Comments:

Post a Comment

<< Home