Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Re: Re: Calling SQL with embedded quotes

by mpeppler (Vicar)
on May 21, 2002 at 17:54 UTC ( #168220=note: print w/replies, xml ) Need Help??


in reply to Re: Re: Calling SQL with embedded quotes
in thread Calling SQL with embedded quotes

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://168220]
help
Chatterbox?
and the web crawler heard nothing...

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











    Results (118 votes). Check out past polls.

    Notices?