How to generate same uniqueidentifier for two deffrent tables?
Hi,
How to generate same uniqueidentifier for two deffrent tables?is it possible?it is primary key column.i paste my syntax here.plz give me correct syntax.plz.
CREATE TABLE Persons
(
ID UNIQUEIDENTIFIER DEFAULT NEWID() PRIMARY KEY,
lastname varchar(10) not null,
firstname varchar(10),
)
GO
insert into Persons values(newid(),'ravi','kumar')