RE: SQL Replacement
Michael Whisenant ( mwhisen@airnet.net )
Tue, 05 May 1998 17:09:39 -0500
Well I found the Update statement. Lets say for example I wanted to replace
all the entries in the Table SubAccounts the field is LoginLimit where
LoginLimit=0 I wanted to change it to LoginLimit=1. There is something
about update in place. Any ideas on the script to run.
Here is one sample,
anyone know if this will do what I anticipate?
UPDATE SubAccount
SET
LoginLimit = '1'
WHERE LoginLimit = '0'
GO
Michael J. Whisenant
Vice-President, Operations
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329