Re: Re: Calling SQL with embedded quotes

by Biker (Priest)

on May 21, 2002 at 09:28 UTC ( #168069=note: print w/ replies, xml )

Need Help??

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

Everything went worng, just as foreseen.

Comment on Re: Re: Calling SQL with embedded quotes
Re: Re: Re: Calling SQL with embedded quotes by mpeppler (Vicar) on May 21, 2002 at 17:54 UTC
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]

Node Status^?

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

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others chanting in the Monastery: (15)

As of 2013-05-20 14:24 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?