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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-26 : 11:28:44
|
| Didier writes "Hi,I would like to know if there is a way to insert several rows in a table in one single query/command.Let`s say that i have the MyTable with two fields:MyTableID (Data Type: Int; Identity: Yes; Identity Seed: 1)MyTableNo (Date Type: varchar(50), AllowNull)I want to insert 500 rows in a single query in this table.The value of the field MyTableNo should be "xxx"+MyTableID.Can you help me please.Thanks a lot." |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2004-04-26 : 11:49:29
|
| Without more information, especially about what "Rows" you want to add (some DDL and DML would be helpful with some sample data), it is difficult to help you. The one suggestion I can give is to look up INSERT...SELECT in BOL which allows multiple line inserts to a table. |
 |
|
|
|
|
|
Inserting rows in a table