RE: Changing an SQL table (Best practices)

I haven't tried mass insert, but you can update identity values by
specifying OVERRIDING SYSTEM VALUE clause, i.e.:

UPDATE t1 OVERRIDING SYSTEM VALUE
SET (identity, data_field) = (786, 47) WHERE data_field = 55

You can also reset identity column generator value by doing something like:

ALTER TABLE t1 ALTER COLUMN identity RESTART WITH 1

and then trying mass INSERT... it should generate values as you normally
see.

I wrote an article that touches upon identity attribute for one of our
newsletters:

http://www.centerfieldtechnology.com/publications/archive/April%202006.pdf

see page 8.

Elvis

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
Subject: RE: Changing an SQL table (Best practices)

< ...then I wonder if there is a 
way to include the sequence attribute on a mass INSERT versus a CPYF?>

Rob Berendt