Foreign Key Not Populating with Primary Key Values

by

The foreign keys will not auto-populate, as it doesn’t know what foreign key to use. You need to either insert the rows into the JobTitle_tbl table, then select the IDs back out (or use @@identity if using sql server)

select id from JobTitle_tbl where Job_title=""

Another option would be to update your insert statements to include the primary key, although you’ll have to allow identity inserts first.

SET IDENTITY_INSERT JobTitle_tbl ON
into the JobTitle_tbl (id, title) values (1, 'Manager')
SET IDENTITY_INSERT JobTitle_tbl OFF

In either case, you’ll need to then update your first insert statements with the ID that you have.

insert into Employee_tbl (LastName, FirstName, JobID) values ('Smith', 'John', 1)

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Insert local .csv data in remote SQL Server via already working connection string
  3. Syntax combine two stored procedure into one [closed]
  4. How to delete duplicate rows in SQL Server?
  5. How to cast the DateTime to Time
  6. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  7. How can I schedule a job to run a SQL query daily?
  8. Reset identity seed after deleting records in SQL Server
  9. How to avoid the “divide by zero” error in SQL?
  10. Multiple INSERT statements vs. single INSERT with multiple VALUES
  11. Real life example, when to use OUTER / CROSS APPLY in SQL
  12. Common Table Expression, why semicolon?
  13. T-SQL split string based on delimiter
  14. SQL Server 2008: how do I grant privileges to a username?
  15. How do I find duplicates across multiple columns?
  16. How do I add a foreign key to an existing SQLite table?
  17. Generate Delete Statement From Foreign Key Relationships in SQL 2008?
  18. Generate script in SQL Server Management Studio
  19. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  20. sql varchar(max) vs varchar(fix)
  21. Do clustered indexes have to be unique?
  22. How do I prevent a database trigger from recursing?
  23. store arabic in SQL database
  24. Convert Date format into DD/MMM/YYYY format in SQL Server
  25. Converting Select results into Insert script – SQL Server
  26. How to combine results of two queries into a single dataset
  27. Executing SQL Server Agent Job from a stored procedure and returning job result
  28. Script entire database SQL-Server
  29. Editing Record issues in Access / SQL (Write Conflict)
  30. How to create Daylight Savings time Start and End function in SQL Server

Leave a Comment