Lawrence Avery
asked on
NEWSEQUENTIALID() Function used in sql server table
I have created a table that has a Primary Key column with a Default value of
newsequentialid() specified.
However, every time I insert into the table, the newsequentialid() function keeps generating the same value
0000 0000-0000-0000-0000-000000 000000 . Thus failing to insert more than one row.
How do I get the newsequentialid() to create a new unique value?
newsequentialid() specified.
However, every time I insert into the table, the newsequentialid() function keeps generating the same value
0000 0000-0000-0000-0000-000000
How do I get the newsequentialid() to create a new unique value?
Please post your table creation script.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
See attached script. See the ID column how it is created in the Countries table
This file contains the script.
Countries-SQL.txt
This file contains the script.
Countries-SQL.txt