SQL select and update command

ADSM-L

[Top] [All Lists]

SQL select and update command

2001-10-02 11:14:36

Subject:	SQL select and update command
From:	"Guan, Phillip" <Guan_P AT VDOT.STATE.VA DOT US>
Date:	Tue, 2 Oct 2001 11:06:31 -0400

Hi all,

Could someone give me an example how to do a select and then run command
against the select reqult? For example, I want:

Select volume_name from volumes where access!='READWRITE'
then
update volume the_result_from_select access=readwrite.

Thanks.

Best regards,
Phillip Guan

[More with this subject...]

<Prev in Thread]	Current Thread	[Next in Thread>
SQL select and update command, Guan, Phillip <= Re: SQL select and update command, Mark Stapleton Re: SQL select and update command, Thomas A. La Porte Re: SQL select and update command, Bill Colwell Re: SQL select and update command, Scotty Logan Re: SQL select and update command, Daniel Sparrman

Previous by Date:	Re: compressalways, Cook, Dwight E (SAIC)
Next by Date:	AW: SQL select and update command, Baines, Paul
Previous by Thread:	Re: TDP for Notes, Scott, Brian
Next by Thread:	Re: SQL select and update command, Mark Stapleton
Indexes:	[Date] [Thread] [Top] [All Lists]