Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Calling SQL with embedded quotes

by davis (Vicar)
on May 21, 2002 at 08:34 UTC ( #168064=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://168064]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (5)
As of 2021-03-06 14:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favorite kind of desktop background is:











    Results (116 votes). Check out past polls.

    Notices?