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 - 2006-08-25 : 10:40:10
|
| meenakshi writes "higenerally we can insert only one row in an insert statement.how can yo insert a number of rows(say 10)using a single insert statement?" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-08-25 : 10:59:12
|
| Read about Insert...Select dialect of Insert statement in BOL !Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-25 : 11:35:03
|
[code]insert table (col1, col2, col3 . . .)select val1a, val1b, val1c, . . . union allselect val2a, val2b, val2c, . . .[/code]
KH |
|
|
|
|
|
|
my question on inserting values into the table