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 |
|
Lemmy44
Starting Member
20 Posts |
 Posted - 2004-08-16 : 14:46:00
|
| I have some rows in one table that I need to move to another table. Both tables are identical in structure, except one table has a text field, and the other has a memo field. I need to move these rows based on an ID number.Is this possible, and if so, how would I go about doing it?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-16 : 15:04:21
|
| One table has a memo field? So that table is not on SQL Server? memo isn't a valid SQL Server data type.You would do something like this:INSERT INTO DestinationTableName (ColumnList...)SELECT ColumnList...FROM SourceTableNameWHERE ...Tara |
 |
|
|
Lemmy44
Starting Member
20 Posts |
Posted - 2004-08-16 : 15:07:07
|
| Sorry...response_memo and response_text are the table names...I messed that up.One data type is varchar and the other is text.Thanks for the info though...I'll give it a shot. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-16 : 15:16:55
|
| Is this an access database?INSERT response_memo(column1, column2)SELECT column1, column2FROM response_textblah,blah,blah I would look up INSERT in Books Online if it's SQL Server. If it's Access I would look up INSERT in the help file.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Lemmy44
Starting Member
20 Posts |
Posted - 2004-08-16 : 15:49:59
|
| Yes, it is a SQL database. Sorry for the confusion...should have made that clearer. |
|
|
|
|
|
|
Moving Selected Rows