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!!!

101
102
103

I dont want to use IDENTITY column

Plz...can anyone help

No, but you could use NEWSEQUENTIALID(), which I wouldn't recommend because, per BOL: If privacy is a concern, do not use this function. It is possible to guess the value of the next generated GUID, and therefore access data associated with that GUID.

========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================

By nature of the unique identifier (GUID) it is very "randomized". There is no way to increment it. If you want an incremental ID, use an identity column but note Scott's warning about privacy.

-Peter
peterlanoie.blog

Not quite true in 2k5... there is a new sequential form of NEWID that can be used. You just can't seed it...

--Jeff Moden

Jeff,

Is this new behavior for the existing Unique Identifier type or a new data type?

-Peter
peterlanoie.blog