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 - 2007-03-26 : 08:58:40
|
| Harsh sent us this one. He writes "Just came across the post on how to pass array of values without normal CSV parsing on Tony Rogerson's blog." Tony uses dynamic SQL to parse out the values in the string. Article Link. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-03-26 : 09:29:03
|
| What is the advantage of this technique over any other? I can't think of one reason to do it this way. I see lots of cons (dynamic sql, temp tables, no UDF's, can't use in a VIEW, limited to size of the numbers table) and no pros.- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
|
|
|
Article: Passing an array of values to SQL Server (Stored Procedure) without parsing/string manipula