zhj
November 20th, 2007, 02:05 AM
in update table , where id = 15. if id =15 does not exist, why i do not get error?. does it do anything to the table?. server2000.
Click to See Complete Forum and Search --> : query analyzer
davide++
November 20th, 2007, 03:40 AM
Hi all.
The UPDATE command modifies a set of records, the records that meets the WHERE condition. If the WHERE condition defines n records the command will modify n records, and when n = 0 no record will be changed; but this isn't an error, it's the behaviour of UPDATE.
The UPDATE command modifies a set of records, the records that meets the WHERE condition. If the WHERE condition defines n records the command will modify n records, and when n = 0 no record will be changed; but this isn't an error, it's the behaviour of UPDATE.
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.
Copyright Internet.com Inc., All Rights Reserved.