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 |
|
vgr.raju
Yak Posting Veteran
95 Posts |
 Posted - 2007-06-28 : 23:54:32
|
| Hi, I have the scenario where I am inserting multiple MB of Unicode Data in Temp Tables.I am using the simple syntax.insert into #temptable Select column1,column2,column3.I can't use the files are bulk insert,which restricts my ability to use any efficient way of insert the data.Is there any way I can optimize the insert to the temp table.Thanks,RajuThanks!Rajuhttp://rajusqlblog.blogspot.com/ |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-29 : 04:13:00
|
| What you have looks good to me.Maybe use a @TempVariable rather than a #TempTable ?How many rows are you inserting?Kristen |
 |
|
|
|
|
|
How to perform efficient insert