Performing updates with joins  Changing text, unitext, and image data

Chapter 7: Adding, Changing, and Deleting Data

Updating IDENTITY columns

You can use the syb_identity keyword, qualified by the table name, where necessary, to update an IDENTITY column. For example, this update statement finds the row in which the IDENTITY column equals 1 and changes the name of the store to “Barney’s”:

update stores_cal
set stor_name = "Barney’s"
where syb_identity = 1



Copyright © 2005. Sybase Inc. All rights reserved. Changing text, unitext, and image data

View this book as PDF