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 |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-05-05 : 02:14:40
|
| I want to know what are the ways of transfering data between tables and which one is he fastest? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-05 : 02:24:15
|
| 1. from what source to which destination (server to server or just within the database)?2. amount of data to be transferred?--------------------keeping it simple... |
 |
|
|
bridge
Yak Posting Veteran
93 Posts |
Posted - 2005-05-05 : 03:29:07
|
| from database to database (data could be any in number) |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2005-05-05 : 04:31:07
|
| 1) BULK INSERT2) BCP3) INSERT.. SELECT...4) Manual data entry5) A thousand monkeys using a thousand keyboards6) Quantum fluctuatation. Eventually the data will just "appear".. it may take 12 billion years or so..7) A cursorDavidMA front-end is something that tries to violate a back-end. |
|
|
|
|
|
|
What is the fastes way of transfering data