Re: Re: Re: Calling SQL with embedded quotes


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

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

Michael

Comment on Re: Re: Re: Calling SQL with embedded quotes Download Code

In Section Seekers of Perl Wisdom

Log In^?

Node Status^?

node history
Node Type: note [id://168220]
help

Chatterbox^?

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^?

Notices^?