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: SQL Server 2008, T-SQL
















0 Comments:
Post a Comment
<< Home