I have a transaction with several steps that I need to accomplish. I'm
trying to decide if I should manage that transaction from my vb.net program
or put the whole thing in a single Stored Procedure. It involves an array
of strings that would require numerous inserts into a table. After looking
through chapter 10 in "Inside Sql Server 2000" (the only T-Sql ref I have) I
don't see the capability to pass an array or a collection to Sql Server so
I'm thinking I should contro the transaction from my program.
Is there an array datatype in T-Sql? Can ...