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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-17 : 07:52:30
|
Alan Nelson writes "I have a performance question:
I have a delimited string of values, and I want to insert each of these values into a SQL Server table. Assume the delimited string value is less than 8000 characters....
As I see it, I have two options:
1.) I can "break out" each value from the string in a middle-tier component, and then loop through the string - sending each value to a stored proc which inserts the value.
2.) I could send the entire delimited string to SQL Server at once... and use T-SQL string manipulation to "break out" each value from the string into a temporary table... and then run a single INSERT statement against that temp table.
Where should I do the string manipulation to break the values out of the string?
Thanks...
- Alan" |
|
|
|
|
|
Database vs VB string manipulation