http://qs321.pair.com?node_id=168064


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.

[reply]
      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 ...

      [download]
      The same syntax can be used for UPDATE. Very nice for doing set based operations.

      Michael

[reply]
[d/l]

In Section Seekers of Perl Wisdom