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 |
|
adh
Starting Member
4 Posts |
 Posted - 2008-05-06 : 02:50:28
|
| In a sp I have to regenerate data for a small dynamic temporary table (up to 10 rows) a couple of hundreds times.What should be faster: 1) DROP, CREATE, INSERT or2) Create once. and than TRUNCATE, INSERT x 200....Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-06 : 04:07:55
|
| Why do you want to do this? and if you are really inclined on doing this, i think second method is better. |
 |
|
|
|
|
|
A Q of speed ?