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 |
|
ziqew
Starting Member
2 Posts |
 Posted - 2004-10-13 : 22:30:14
|
| hi,all i have a problem.first i do a select query like this.i want insert more than one records into a table by one time .what shoud i do.SELECT nameFROM syscolumns LEFT OUTER JOIN sysobjects ON syscolumns.id = sysobjects.idWHERE (sysobjects.xtype = 'U')i get a lot of record about name,and i want insert the values of the name of the records into another table's field columnName. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-10-13 : 23:12:08
|
| insert tbl (columnName)SELECT nameFROM syscolumns LEFT OUTER JOINsysobjects ON syscolumns.id = sysobjects.idWHERE (sysobjects.xtype = 'U')==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ziqew
Starting Member
2 Posts |
Posted - 2004-10-13 : 23:19:08
|
thx |
|
|
|
|
|
|
insert problem