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 |
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
 Posted - 2003-10-23 : 05:58:49
|
Sooner or later, somebody's gonna ask that million row question (what, it's been done already??!!)...so here's the answer:http://www.codeproject.com/cs/database/PassingArraysIntoSPs.aspI am not sure if the tricks he's used are bug-free, but read the article anyway, he's used some pretty interesting techniques. Owais
Make it idiot proof and someone will make a better idiot |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-10-23 : 07:31:13
|
| That is kinda cool.I shudder to think how long it would take to pump in a million rows though, BCP is probably faster.Nice idea though.For anyone that can't be bothered reading the link, the author has a UDF that takes a byte array in the form of an Image parameter. It takes it apart byte by byte and inserts it into a table variable.If that interests you, the article is worth a read.Damian |
 |
|
|
|
|
|
Passing a one-million record Dataset to SP