Insert multi values into a table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Insert multi values into a table

Author

Topic

haibec
Yak Posting Veteran

54 Posts

Posted - 2007-02-22 : 22:22:29

I want Insert multi values same same into a table .Please help me

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-22 : 22:26:00

[code]
insert into table1(col1, col2, col3)
values (10, 20, 30)
[/code]

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-22 : 22:41:29

multiple values or records?

insert into table1(col1, col2, col3)
select 1, 1, 1 union all
select 2, 2, 2 union all
select 3, 3, 3 union all
select 4, 4, 4

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources