Re: Avoiding any locks in SQL Servers - read and understand....itsmagic.

After a long battle with technology,"Noons" <wizofoz2k_at_yahoo.com.au>, an earthling, wrote:
>> Did you know, that with many API's (PHP...) you cannot separate several
>> sql statements by semicolon ? Only one statement is allowed, one
>> resultset you can receive. You have to put 2+ statements into a stored
>> procedure to get them executed.
>
> Thats is true for MOST api's, in fact.

.. And it doesn't necessarily mean that those statements are forced to be in different transactions ...

But the number of other misconceptions seems quite stunning...

-- 
(format nil "~S@~S" "cbbrowne" "cbbrowne.com")
http://cbbrowne.com/info/sap.html
"Programming today  is a race  between software engineers  striving to
build bigger and better  idiot-proof programs, and the Universe trying
to  produce  bigger  and  better  idiots.  So  far,  the  Universe  is
winning."  -- Rich Cook