|
|
Posted by drawnai on 04/24/06 11:20
David Portas wrote:
> drawnai@hotmail.com wrote:
> > >
> > > As for your comments about updates that affect multiple rows being
> > > undefined, I'm afraid you're wrong.
> > >
> > > Update table set @fred = column = @fred + 1 is defined in SQL server's
> > > own help, please look it up if you don't believe me.
> > >
>
> There is a difference between valid syntax and defined behaviour. BOL
Defined behaviour is as defined behaviour does. Outperforming an
equivalent
query ten to one is worth a rewrite 5 years from now, in the unlikely
event
that microsoft, remove the ability. (This goes against all precedents
as MS
have done very little but improve ability rather than remove it.)
I understand your purist position though, I used to be a software
engineering
purist, but after 30 years of writing code, I now hold the cost benefit
analysis
position. If I can generate, orders, multidimensional rolling averages,
and all
kinds of crap with a single pass of a table, rather than generating a
gig of
transaction log, and 5 Gig of tempdb allocation, then I do it.
Similarly, if I can implement the kind of parametric query, like
dabs.com's have
done, and multiorder search facility, at basically no cost, then I do
it.
By the time MS remove this facility, they'll replace it with something
better,
so there's no worries.
Navigation:
[Reply to this message]
|