|
|
Posted by Erland Sommarskog on 09/29/07 15:59
bobc (bcanavan@fmbnewhomes.com) writes:
> ps: es, the output string "array" was intended to be parsed by my
> vb.net app.
Also in that case it would be better to return a result set and receive
that in a datatable in VB .Net. The code for composing the list is
dependent on the number of elements being fixed. Add one more value,
and you have a maintenance job to do. With result set + datatable you have
not.
> I just got a little curious about how arrays could be
> implemented in t-sql, and possibly save some calls to the db server by
> my app, or at least reduce the number of batches. I'm sure it's all
> been done before, but I had to try and fail for myself.
You may be interested in this link for a rainy day:
http://www.sommarskog.se/arrays-in-sql.html.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|