How to seed or increment NEWID() value

[sujathaeeshan]

Hi all,

Newid() which creates a unique value of type uniqueidentifier.

Is there any possibolities for seeding or incrementing the NEWID() value.

For example:

create table cust(cust_id uniqueidentifier NOT NULL
DEFAULT newid(),cust_name varchar(60) NOT NULL)

For insertion example:
INSERT cust (cust_id, contact_name) VALUES (newid(), ' ABC ' )
INSERT cust (cust_id, contact_name) VALUES (newid(),' XYZ ' )
INSERT cust (cust_id, contact_name) VALUES (newid(), ' PQR ' )
If i am inserting more then one row detail NEWID() creates uniquevalue.

But i want to increment the NEWID() value is that possible!!!

Plz...can anyone help

[docdiesel]

Hi,

do I understand you right, you'd like to get the first user uid=10000, the next one 10001 and so on? You could use a sequence:

create sequence
  seq_uid       as integer
  start with    10000
  increment by  1
  minvalue      10000
  no maxvalue
  no cache
  no cycle
;

The next free uid value would be selectable by "select nextval for seq_uid from sysibm.sysdummy1".

Regards,

Bernd