in reply to Calling SQL with embedded quotes

Should "delete sometable" be "delete from sometable"?
cheers.
davis
Is this going out live?
No, Homer, very few cartoons are broadcast live - it's a terrible strain on the animator's wrist

Replies are listed 'Best First'.
Re: Re: Calling SQL with embedded quotes
by Biker (Priest) on May 21, 2002 at 09:28 UTC

    No. In Sybase Transact-SQL, the from keyword in a delete statement is optional.


    Everything went worng, just as foreseen.

      The reason the FROM is optional is that you can do the following in Transact-SQL:
      delete mytable from mytable m, theirtable t where m.somevalule = t.somevalue and ...
      The same syntax can be used for UPDATE. Very nice for doing set based operations.

      Michael