foreign key concept

Question

i want to insert values in one table then automatically insert in another table using primary and foreign key concept. i am using sql server 2008 i am taking same fields in both table

Abhishek Jaiswal · Answer

Hey! Just take ref of this.. ( it is for 2 table named submissions and submittedItems ) -- populate tables with sample data DECLARE @totalRecords int SET @totalRecords = 0 DECLARE @currentKey int WHILE @totalRecords BEGIN SET @totalRecords = @totalRecords + 1 INSERT INTO dbo . submissions ( submissionName , dateSubmitted ) VALUES ('submission record ' + cast ( @totalRecords AS varchar ( 3)), SYSDATETIME ( )) Set @currentKey = Scope_Identity ( ) INSERT INTO dbo . submissionItems (fk_submission_id, item) VALUES (@currentKey, 'a new record item for submission '+ cast ( @totalRecords AS varchar ( 3))) END All the best.

Manish Kumar Choudhary · Answer

Actually foreign key primary key relationship will never do such automatic insertion in one table to another table. For doing that you have to write your own code or implement some logic that will do it. Best way to do this create a trigger that fire when data insert on your first table. For creating a trigger go through following link. http://www.tech-recipes.com/rx/41414/sql-server-coding-the-after-insert-trigger-in-sql-server/ http://www.codeproject.com/Articles/25600/Triggers-SQL-Server

foreign key concept

Answers (2)