How to generate same uniqueidentifier for two deffrent tables?

Question

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' )

Roei Bar · Answer

well my fridend the idea of Uniqeidentifier is that its uniqe if you want to put the same key on 2 differant tables just do the following declare @myKey uniqueidentifier select @myKey = newId() and than do the insert to both Tables with the @myKey Indicator if you liked this dont forget to mark it as Accepted Answer