Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
36004 Points
7901 Posts
Sep 29, 2009 09:55 PM|LINK
SQL Server 2005 and down
insert into table (ID) select '1' union select '2' union select '3'
SQL Server 2008
insert into table (ID) values ('1'), values ('2'), values ('3')
Naom
All-Star
36004 Points
7901 Posts
Re: Insert multiple rows from sql statement?
Sep 29, 2009 09:55 PM|LINK
SQL Server 2005 and down
insert into table (ID) select '1' union select '2' union select '3'
SQL Server 2008
insert into table (ID) values ('1'), values ('2'), values ('3')
(Donald Knuth)
Visit my blog
Microsoft Community Contributor 2011-12