Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #300

Re: SSE 2008: Handling Transaction Batches

Show all headers | View raw

On Fri, 06 May 2011 23:46:56 +0200, Erland Sommarskog
<esquel@sommarskog.se> wrote:

>Gene Wirchenko (genew@ocis.net) writes:
>>      I want to post batches of transactions.  The transactions have to
>> pass various checks.  The transaction must balance to zero.  Only
>> certain transaction type combinations will be allowed.  It must be
>> possible to modify a batch's transactions and have all of the
>> aforesaid checks done.
>> 
>>      I see two ways to go about it.
>
>Unfortunately, this is a bit too vague to be able to say what might be
>the best. All I can say is that from the business domain I come from,
>updating transactions is a big no-no. You can cancel them, but you 
>cannot modify them.
>
>But I suspect that this is just a made-up exercise you make for your 
>training. So why not do both solutions, and see which one you like the
>best?

     Not made up.  I may well use it.  I do not need auditing
capability.

     Because if I did that every time I ran into an issue, I still
would not know what is the better *general* solution.  I want to know
that.  If a particular application is written less efficiently, that
is acceptable to me as long as I have a generally good method.  (I can
fine-tune later.)

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SSE 2008: Handling Transaction Batches Gene Wirchenko <genew@ocis.net> - 2011-05-05 16:25 -0700
  Re: SSE 2008: Handling Transaction Batches Erland Sommarskog <esquel@sommarskog.se> - 2011-05-06 23:46 +0200
    Re: SSE 2008: Handling Transaction Batches Gene Wirchenko <genew@ocis.net> - 2011-05-06 15:06 -0700
      Re: SSE 2008: Handling Transaction Batches Erland Sommarskog <esquel@sommarskog.se> - 2011-05-07 15:09 +0200
        Re: SSE 2008: Handling Transaction Batches Henk van den Berg <hvandenberg@xs4all.nl> - 2011-05-07 18:31 +0200

csiph-web