I have uniqueIdentifiers as foreign keys

• dazzaman

  Grasshopper

  Points: 13

  More actions

  June 22, 2009 at 6:48 pm

  #132038

  Hi, I have used uniqueidentifiers as primary keys but can't seem to reference them as foreign keys properly in my tables. As a result, my inserts aren't working on the tables with foreign keys.

  Here's a snippet:

  CREATE TABLE dbo.Apartment(

  apartmentID UniqueIdentifier Primary Key NOT NULL Default NewID(),

  apartmentDescID UniqueIdentifier Foreign Key References dbo.ApartmentDescription(apartmentDescID) NOT NULL,

  apartmentNumber Nvarchar(20) NULL,

  apartmentFloorLevel Nvarchar(20) NULL,

  apartmentVacant Nvarchar(5) NULL

  )

  and here's the inserts:

  Insert Into dbo.Apartment(apartmentID, apartmentDescID, apartmentNumber, apartmentFloorLevel, apartmentVacant)

  Values(Default, ?, '22A', '2', 'Yes')

  Insert Into dbo.Apartment(apartmentID, apartmentDescID, apartmentNumber, apartmentFloorLevel, apartmentVacant)

  Values(Default, ?, '7', '1', 'Yes')

  Insert Into dbo.Apartment(apartmentID, apartmentDescID, apartmentNumber, apartmentFloorLevel, apartmentVacant)

  Values(Default, ?, '20', '2', 'Yes')

  Will I need to hardcode the uniqueidentifier? (the question marks indicate where the FK value should be)

• Pandian S

  SSChasing Mays

  Points: 625

  More actions

  June 25, 2009 at 5:02 am

  #1015201

  [font="Verdana"]Insert Into dbo.Apartment(apartmentID, apartmentDescID, apartmentNumber, apartmentFloorLevel, apartmentVacant)

  Values(Default, ?, '22A', '2', 'Yes')

  Insert Into dbo.Apartment(apartmentID, apartmentDescID, apartmentNumber, apartmentFloorLevel, apartmentVacant)

  Values(Default, ?, '7', '1', 'Yes')

  Insert Into dbo.Apartment(apartmentID, apartmentDescID, apartmentNumber, apartmentFloorLevel, apartmentVacant)

  Values(Default, ?, '20', '2', 'Yes')

  UniqueIdentifier should be placed insteadof ? ( which is available at PK table of apartmentDescID)[/font]