INSERT Auto Incremented PK from Table A into FK of Table B

Riyaz Akhtar13y ago

Accepted answer

Check below code

insert into tbl_Class(className,noOfseats)

values('10th',50)

declare @classId numeric

set @classId=@@IDENTITY

INSERT INTO tbl_Division:

(divisionName,classId)

VALUES('divisionName',@classId)

Bineesh Viswanath13y ago

Sir, I am upset of not to have a clear idea on SQL Normalization.

Here I attached a MS Word File includes my doubts is been included in the form of questions.

I request you to send me the answers for all these questions.

Ravi Shekhar13y ago

Hi bineesh ,

You can make PK auto increment from tbl_A to the FK in tbl_B. and it will work properly.

Bineesh Viswanath13y ago

I am very sorry to say that this code is working, but the output is not i expected

auto increment of classId(PK) from tbl_Class tbl_Division where classId is Fk, not happening.